I have a set of excel export queries I created in an access 2003 DB. Now,
some of my users have upgraded to Access 2007 and are running in to a
"Parameter" error when the execute the "canned" excel export queries I
created for them. My only presumption is that it is due to the fact that I
have hardcoded the export function, to go to an Office 2003 Excel file, and
for whatever reason, Access 2007 cannot handle this.
This make sense? And if so, any suggestions? I suppose if there was an easy
way to test what version of office/excel they are running, I could change the
parameter on the export based upon which Office version they run. Sound
reasonable, and if so, how? Thanks!