TransferSpreadsheet to Excel Template?

[Carlos Duran Urenda]

Hi

I need use TransferSpreadsheet command to export a data table to a
pre-formated Excel book

It is possible?

Thanks

 

[fredg]

Hi

I need use TransferSpreadsheet command to export a data table to a
pre-formated Excel book

It is possible?

Thanks

Did you not look up the TransferSpreadsheet method in VBA help?
Is there a problem you are having using that information?
We can't read your mind. If you have a specific problem you have to
provide us with the specifics.

 

[Carlos Duran Urenda]

SPECIFIC PROBLEM:
TransferSpreadsheet command exports to A SIMPLE EXCEL BOOK

I need export to PREFORMATED BOOK stored as a Excel Template


can you understand now???

 

[Ken Snell \(MVP\)]

If your data are going to be contiguous in the formatted EXCEL worksheet,
then the information at the link below may be useful:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

If the data are not contiguous in the workbook, then you'll need to use
Automation to open the EXCEL workbook file, and then use a recordset that
contains your data and loop through the recordset to write the data directly
into the worksheet where you want it to go.
--

Ken Snell
<MS ACCESS MVP>

SPECIFIC PROBLEM:
TransferSpreadsheet command exports to A SIMPLE EXCEL BOOK

I need export to PREFORMATED BOOK stored as a Excel Template


can you understand now???

 

[Carlos Duran Urenda]

EXCELENT!!!

If your data are going to be contiguous in the formatted EXCEL worksheet,
then the information at the link below may be useful:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

If the data are not contiguous in the workbook, then you'll need to use
Automation to open the EXCEL workbook file, and then use a recordset that
contains your data and loop through the recordset to write the data
directly into the worksheet where you want it to go.