I am stuck right at the end of this database and I just need a little bit of help. After I have entered all my information into my form I run a macro which generates query results. What I would then like to do is export these results to an excel workbook that I already have made, just make it create a new sheet at the end. I am using the "Output To" command in the macro but I guess I'm not sure if I should use this or the "TransferSpreadsheet" command and what path to send the file as. If anyone can help me with this it would be greatly appreciated. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exporting to excel
- Thread starter phil009
- Start date
Make a new macro any name and add the following
Macro Name: Print Report Action: OutputTo
ObjectType: Report
Ojject Name: Name of Report
Output Format: MS excel 5-7
Output File: Name of output file
Auto Start: Yes
On the form have a button that call the macro.
Macro Name: Print Report Action: OutputTo
ObjectType: Report
Ojject Name: Name of Report
Output Format: MS excel 5-7
Output File: Name of output file
Auto Start: Yes
On the form have a button that call the macro.
- Status
Similar threads
