Export Report to a Worksheet

  • Thread starter Thread starter Jen Scott
  • Start date Start date
J

Jen Scott

I need to export a report into a specific worksheet within a workbook (Access
7.0 and Excel 7.0). I can get it to export to a new workbook or replace an
existing workbook, but need to replace an existing worksheet in a workbook.
Thanks!
--
Jen Scott

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...97860&dg=microsoft.public.access.externaldata
 
Jen,

i have used:
docmd.TransferSpreadsheet(TransferType, SpreadsheetType, TableName,
FileName, HasFieldNames, Range, UseOA)
for example:DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"query/worksheet_name", "C:\Documents\Workbook_name.xlsx", True
i would recommend reading the help on TransferSpreadsheet.

i use this to export a query used for graphs created in a word document.
hope this helps.
 
Back
Top