Report output in Excel

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

Guest

Was wondering if its possible to have the report output in Excel and how can
it be done?

Thanks
MSA
 
Was wondering if its possible to have the report output in Excel and how can
it be done?

Thanks
MSA
Click to expand...
Is your report based on a Query? If yes,
1. make a macro:
output to:
Object Type = query. Object Name = name of your query.
Output Format = Microsoft Excel (*.xls).
Output Fi;e = ="{full path}\{name you want for the output file} " &
(Format(Date(),"yymmdd")) & ".xls"
The format date part is not required, but can be handy.

or

2. File/*Save As/Export*/To an external file or database/
Enter the name you want for the file, chose where you want the file to be
saved. and chose *save as type* Microsoft Excel {version}

Chuck
--
 
Back
Top