Export to Excel - Invalid Procedure call

[Moses76]

When I try to do an export to excel for a report - it comes back with a message saying Invalid procedure call or arguement . Any ideas on this one ?

 

[CJ_London]

There are many ways of exporting to Excel, which one are you using?

 

[Moses76]

There are many ways of exporting to Excel, which one are you using?

.

Using the transfer spreadsheet method . It was giving that message yesterday but today it disappeared . Today my problem is when I put in the path to a folder on the shared drive it does not export . When I put the database on my hard drive and give the path of C:\Data.xls it works fine. So the issue is with exporting when it is placed on the shared drive. any ideas about that ? Thanks for your reply.

 

[CJ_London]

If you are transferring to a network drive - are you using mapping? i.e. h:\... or drive name \\yournetwork\....?

If the former, is the drive still mapped and/or try the latter which is generally more reliable.

Also, I presume the full path is valid?