Export to Excel

  • Thread starter Thread starter Annette
  • Start date Start date
A

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.
 
Annette said:
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.
Click to expand...


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
 
Back
Top