Exporting with Range?

[Mark]

Hello all,

I'm wanting to export a table to an excel spreadsheet, but putting the data
in a location of my choosing.

TransferSpreadSheet help says you can not use the range on an Export.
However, I did a search here and someone said that it would work.

It partially works, but I can't seem to get it to allow me to put it in a
workbook. Also, it will not overwrite if the file exists already.

Is there something better to use to export data in a range of my choosing,
or what am I doing wrong with transferSpreadsheet.

Docmd.transferspreadsheet acExport, , "tbShiftHld","C:\Test.xls", True,
"B251:F25"

 

[Ken Snell \(MVP\)]

See Alex Dybenko's recent blog for some info about how to use
TransferSpreadsheet for naming a spreadsheet page:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

 

[Mark]

Very useful link, thanks!

See Alex Dybenko's recent blog for some info about how to use
TransferSpreadsheet for naming a spreadsheet page:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html