Export to Excel Access 2003 report in Access 2007

[digger]

I have several databases I maintain which are currently in Access 2003 format, however several of my clients want to upgrade to Access 2007. I have successfully transfered the custom toolbar in Access 2003 to a Menu Bar in 2007 and removed the Ribbon from view. The problem I have is that the 'Export to Excel' icon on my custom Menu bar gives me the following error:'The format in which you are attempting to output the current object is not available'. I have set my Excel to save in 97-2003 format and if I allow the Ribbon to show and use the Icon to Export to Excel from there it works. Does anyone have any suggestions as I really need to use the existing Menu Bar Icons if at all possible!

 

[vbaInet]

You could create an export routine and after successful setup use that Saved Export for exporting to Excel.