Send report to Excel

  • Follow


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.
0
Reply anjee 12/28/2007 2:24:34 AM

On Dec 27, 9:24=A0pm, anjee <anjee...@cogeco.ca> wrote:
> I have created a macro in my Access application that uses the
> RunCommand action with the SendToExcel command. =A0When I run my report
> in print preview mode this option (Send To Excel...) is grayed out or
> disabled. =A0I am using the runtime version of 2003 and my version of
> Excel is also 2003. =A0Is this a missing reference issue? =A0An add-in
> that was not installed? =A0Any help is appreciated.

Sorry the action that I use is 'OutputToExcel' and not 'SendToExcel'.
0
Reply anjee 12/28/2007 2:57:34 AM


You could create a custom menu bar that would allow you to "Send" the report 
to Excel.  That is how I did it in a database I created.



"anjee" wrote:

> On Dec 27, 9:24 pm, anjee <anjee...@cogeco.ca> wrote:
> > 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.
> 
> Sorry the action that I use is 'OutputToExcel' and not 'SendToExcel'.
> 
0
Reply Utf 12/29/2007 6:22:01 AM

2 Replies
391 Views

(page loaded in 1.09 seconds)

Similiar Articles:
















7/24/2012 4:43:42 PM


Reply: