I am trying to export query results
to an Excel workbook. I217;ve set up a button using the ‘Edit ButtonR17;
wizard. ‘Output to’ selecting ‘Application217; and then
selecting the ‘Export Options217; wizard.
In the ‘Application217; box
I have specified Microsoft Excel
On the ‘Execute command line’;
I have excel.exe followed by a space and the path to the workbook I am saving
to. Here in lies the problem. The excel.exe part of the command line is supposed
to open Excel before the path to my workbook opens the workbook I want.
How do I program my machine to recognize
‘excel.exe’; is the command to open my Excel?
If I program in the path to Excel (C:\ProgramFiles\MicrosoftOfficeXP\Office10\Excel.exe)
it works, but I am transferring to another machine and want to use the shortcut
‘excel.exe’ and would rather use this in the command line so I don’t
have to go back and reprogram all my buttons.
Ralph Yehle
Minnesota Department of Human Services
Program Assessment & Integrity
Division
651) 282-5439
Caution: This
e-mail and attached documents, if any, may contain information that is
protected by state or federal law. E-mail containing private or protected
information should not be sent over a public(nonsecure) Internet unless it is
encrypted pursuant to DHS standards. This e-mail should be forwarded only on a
strictly need-to-know basis. If you are not the intended recipient, please: (1)
notify the sender immediately, (2) do not forward the message, (3) do not print
the message and (4) erase the message from your system.
|