TransferSpreadsheet

G

Guest

Hi,

I have a query that i want to export to an already setup excel workbook,
into a regular range.

Basically, the spreadsheet i want it to export to is called 'Initial Plans',
into a tab called 'Initial Version', and into a undetermined range but
starting at cell A6.

However, when i use the TransferSpreadsheet function and enter 'Initial
Version!A6:Z1000' into the range identifier it brings back the following;

'Initial Version$A6:Z1000' is not a valid field name. Make sure it does not
incleude invalid characters or punctuation and that it is not too long.

I've checked the path and everything is correct - any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to import a specific sheets data from excel into access? 1
linking an excel file 1
Use transferspreadsheet in macro, randomly receive error 2950 8
"External table not in expected format" 7
TransferSpreadsheet 1
Transferspreadsheet and replacing existing data 2
Exporting with Range? 2
TransferSpreadsheet - If empty do not export 1

Top