Exporting data to specific cell in Excel.

[Guest]

I have a formatted spreadsheet that I use to send out a weekly report.
Currently I have the date export in the spreadsheet and copy and paste in the
formatted area. It is possible to have the data export to s specific sheet
and a location within the spreadsheet?
Thanks

 

[Ken Snell \(MVP\)]

You can use TransferSpreadsheet to export to an existing, formatted EXCEL
spreadsheet by careful, limited use of the "Range" argument
for the method. See
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

Otherwise, you'll need to use Automation to manipulate the EXCEL file and
spreadsheet.

 

[Guest]

Thanks Ken
I will give it a try.

You can use TransferSpreadsheet to export to an existing, formatted EXCEL
spreadsheet by careful, limited use of the "Range" argument
for the method. See
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

Otherwise, you'll need to use Automation to manipulate the EXCEL file and
spreadsheet.