TransferSpreadsheet Question

[IMO]

I'm using the following code to transfer a table to an existing excel spreadsheet

DoCmd.TransferSpreadsheet acExport, 8, "Shipping Details", "H:\BIDataLoad\Supplier Orders.xls", True, "Shipping Details"

The problem I'm having is, it creates a sheet called Shippiing_Details not Shipping Details. Is there something I'm doing wrong or am I just going insane? I need it to be called Shipping Details as I've created several DTS Packages that link to that page. Any help greatly apreciated

IMO

 

[namliam]

Thats one of the many possible problems when using spaces in names and coding.... So dont do that in future !!

You might change the name in excel (using automation from access), but dont know any other way... maybe someone else...

Regards

The Mailman

 

[IMO]

Thats one of the many possible problems when using spaces in names and coding.... So dont do that in future !!

Thanks for the reply.

Problem is, these are not my spreadsheets and the company refuses to change sheet names etc.
When you say "using automation from access", what do you mean?

IMO

 

[namliam]

I mean just what i said, you can control/change Excel sheets from VBA in Access. Check out threads in the excel forum to see... you will have to activate a reference and create an excel object but then you can do everything you want to an excel file like you would do manually from excel.... like rename a sheet....

Regards

 

[IMO]

Thanks, I'll take a look

IMO