Export to Excel

[Annette]

I have a macro that performs the "TransferSpreadsheet". The transfer
type is export, spreadsheet type is Microsoft Excel 8-10, the table
name is a query that I gather information to, the file name is the
name of an existing excel file that I would like to transfer the data
to, has field names is yes and range is "Sheet1!A12:M300".

When I run the macro I would like the data from the "table name" to
dump to the excel file in Sheet1 beginning at cell A12 through M300,
however I receive a message that it failed. I can export the data to a
different spreadsheet and then copy and paste it into the cells and
not have a problem. What am I missing.

 

[Clif McIrvin]

I have a macro that performs the "TransferSpreadsheet". The transfer
type is export, spreadsheet type is Microsoft Excel 8-10, the table
name is a query that I gather information to, the file name is the
name of an existing excel file that I would like to transfer the data
to, has field names is yes and range is "Sheet1!A12:M300".

When I run the macro I would like the data from the "table name" to
dump to the excel file in Sheet1 beginning at cell A12 through M300,
however I receive a message that it failed. I can export the data to a
different spreadsheet and then copy and paste it into the cells and
not have a problem. What am I missing.

I understand that what you want to do is not possible ... you can create
a new worksheet (new workbook?) and then manupulate the data, but you
cannot *update* an existing spreadsheet.

Something about a lawsuit in the past ....

https://groups.google.com/group/mic...st&q=export+to+excel+lawsuit#0eb0bb388074d2e0

 

[Ken Snell]

See this article for more information about the use of the Range argument
when exporting to an EXCEL spreadsheet using TransferSpreadsheet:

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange

 

[Clif McIrvin]

See this article for more information about the use of the Range
argument when exporting to an EXCEL spreadsheet using
TransferSpreadsheet:

Using the Range Argument of TransferSpreadsheet when Exporting Data to
an EXCEL File (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#ExpRange

Thanks, Ken ... That's a "Keeper", for sure!