Export to Excel 2000 and making an Access report at the same time

T

Terri

I don't know if you have gotten your answer or not but
there are several ways you can do this.

After the report is created

1.) click tools, Office Links, Analyze It with MS Excel

2.) Create a Macro - use the Action: OutputTo, at the
bottom the Action Agruments:
Object Type: Choose from List Report
Object Name: Choose from List: Name of Report
Output Format: Choose from List: Microsoft Excel
Output File: the file you want it save to ex:
C/MyDocuments
Auto Start: Yes or No

I hope this helps if you had not gotten a response.
 

Ask a Question

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.

Ask a Question

Top