Transfer Spreadsheet Problem

[Guest]

I am using a Macro to do a export of data from Access to Excel.

The version I put this together in is Access 2003. And it works perfectly.

When I installed it on the user's computer, which has Office 2000, I
encountered an error.

It appears the macro keeps looking for Excel 2003 instead of now looking for
Excel 2000.

I re-created the Transfer Spreadsheet Action, but it still halts saying that
it can't run the application, and shows the path to Excel 2003 (which of
course doesn't exist on this computer).

I can't find anywhere to change the path to excel.

Any suggestions?

Thanks,

Santara

 

[Ken Snell [MVP]]

You likely need to change the references from Office 11 to Office 9 in the
VBA editor for the user's copy of the database. Do that while the database
is on the user's PC.

 

[Guest]

Hi Santara,

I am not using Access 2003, but I ran a quick test for you using Access
2002. One of the arguments for the TransferSpreadsheet action is "Spreadsheet
Type". In Access 2002, the available choices include "Microsoft Excel 8-10"
and previous versions of Excel. Check the macro in Access 2003 to see if
another option has been added, maybe something like Microsoft Excel 11. If
you find this, then set the argument to use version 8-10.

Also, FYI, the TransferSpreadsheet action works correctly with the default
references. Thus, a reference to the Office Library is not required.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________


:

I am using a Macro to do a export of data from Access to Excel.

The version I put this together in is Access 2003. And it works perfectly.

When I installed it on the user's computer, which has Office 2000, I
encountered an error.

It appears the macro keeps looking for Excel 2003 instead of now looking for
Excel 2000.

I re-created the Transfer Spreadsheet Action, but it still halts saying that
it can't run the application, and shows the path to Excel 2003 (which of
course doesn't exist on this computer).

I can't find anywhere to change the path to excel.

Any suggestions?

Thanks,

Santara