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}
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
