G
Guest
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"
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"