Error message when tryin g to run a macro

[will1128]

I re-built an Access 2003 database using 2007 and tried to make it compatible with Access 2003.

I created a Switchboard button which is meant to Export table data to Excel 2003 using the OutputTo macro.

From my PC, which as Office 2007, I can run the macro from the button without a problem. From another PC with Office 2003 the macro fails and I do not understand the error message. Screen shot attached.

Any explanation as to why it happens and how I can fix it would help.

I already tried re-saving the database as an Access 2002 - 2003 database.

Thanks,

 

[jzwp22]

The error message isn't very revealing, but I am guessing that in going between the two versions, Access fails to adjust for the version of Excel. You can check this by going to the Visual Basic for Application (VBA) window and checking under Tools-->References and look for any references designated as MISSING. You will have to uncheck the MISSING reference and find its corresponding one in the list and check it.

 

[boblarson]

I think the arguments might be a problem. There is an extra one in Access 2007 which has PRINT or SCREEN (for Print Quality) as the last option.

But either way - perhaps you might want to scrap that macro and then copy and paste this code from my website into a standard module (not form, report or class module, but standard). Then you can just either call that function with more VBA or a Macro and pass the query name to it.

 

[Nojja567]

Reply

Its good.




Nojja567