TransferSpreadsheet from Access Viewer?

[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

 

[Guest]

What is the Access Viewer? I am not familiar with an Access Viewer.

(david)

 

[Guest]

I mean the Runtime Version, with which one can view forms, but not develop.

 

[david epsom dot com dot au]

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

What kind of behaviour or errors does the user see?

(david)

 

[Guest]

The user don't see anything. All seems OK, but the xls is not updated.

 

[david epsom dot com dot au]

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)

 

[Guest]

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

 

[Guest]

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

Thank you for following up with the resolution.

(david)