I have a query in Access 2000 that needs the results exported to Excel. I need to automate this as much as possible so I've created a form that allows the user to select the criteria for the reports and click on a button that runs a macro that uses the transferspreadsheet command to run the query and send the results to excel. The problem is that the formatting is wrong. If I use the Office Links buttun the format is correct. Can I automate the process so that the query runs and sends the result to Excel in the format office links does?????
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Office Lnks
- Thread starter Ray1127
- Start date
- Status
Similar threads
- Locked
- Question