TransferSpreadsheet

[sdg8481]

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?

 

[Ken Snell \(MVP\)]

See if the info at this website is helpful:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html