Send report to Excel

A

anjee

I have created a macro in my Access application that uses the
RunCommand action with the SendToExcel command. When I run my report
in print preview mode this option (Send To Excel...) is grayed out or
disabled. I am using the runtime version of 2003 and my version of
Excel is also 2003. Is this a missing reference issue? An add-in
that was not installed? Any help is appreciated.
 
A

anjee

I have created a macro in my Access application that uses the
RunCommand action with the SendToExcel command.  When I run my report
in print preview mode this option (Send To Excel...) is grayed out or
disabled.  I am using the runtime version of 2003 and my version of
Excel is also 2003.  Is this a missing reference issue?  An add-in
that was not installed?  Any help is appreciated.
Click to expand...

Sorry the action that I use is 'OutputToExcel' and not 'SendToExcel'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RunCommand - ExportExcel 0
Access Access Report Works on One Machine but not Another 3
Send a single report 8
send object using a maco--filter report 1
Access Automatically Send a notification email once a record is added 0
Access 2007 - the command or action 'quit' isn't available now 10
No data in printed report 2
Send object function with a CSV file 4

Top