TransferSpreadsheet from Access Viewer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've developed an application in which I export data to Excel with some code
like:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, qry1, xls1

and it works perfectly. Now I have a user who has only the Access Viewer and
it appears that the TransferSpreadsheet isn't executed. Is that correct? What
can I do to make it working in the Viewer?

Thanks for help,

Henk
 
TransferSpreadSheet works with the runtime licence the same
as with the retail licence.

What kind of behaviour or errors does the user see?

(david)
 
I'm not sure if you can update an XLS any more.

Have you applied all the service packs to the computer where
it still works? What version of Access are you using where
it still works?

(david)
 
Hi David,
I found it. I didn't use the full pathname of xls in the
TransferSpreadSheet. In my full version the xls is then created in the
working directory and in the runtime version not. Use of full pathname solved
it all.

Thanks for your reactions.

Henk
 
The working directory is probably different on the two PC's.

Thank you for following up with the resolution.

(david)
 
Back
Top