Sending a report to excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I write a code to send a report to excel without having to use a
macro? I have many reports to create but I don't want to clog my database
with macros to do this. Is there a simple way to do this with vba code using
a command button?
 
How can I write a code to send a report to excel without having to use a
macro? I have many reports to create but I don't want to clog my database
with macros to do this. Is there a simple way to do this with vba code using
a command button?
Click to expand...

Have you tried to simply click on the Office Links tool button on the
Report Preview tool bar and select Analyze with Excel.
 
I did not think about that one. Can I put this function into a command
button? I want to make it pretty easy for users to export a report to excel
just by pushing a command button instead of running the report to the screen.
I have it in a macro right now but I don't want 100's of macros.
 
I did not think about that one. Can I put this function into a command
button? I want to make it pretty easy for users to export a report to excel
just by pushing a command button instead of running the report to the screen.
I have it in a macro right now but I don't want 100's of macros.
Click to expand...

DoCmd.OutputTo acOutputReport, "ReportName", acFormatXLS,
"c:\FolderName\FileName.xls", True
 
Back
Top