Macro

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

Guest

I have a macro that will open a make table query and export the spreadsheet.
Is there a way that the macro can also open the server drive and the excel
spreadsheet to be viewed so the user does not have to go to the drive and
open the spreadsheet. Thanks,
 
Pam,

You didn't mention how you are doing this, but assuming you are using an
OutputTo action in your macro to export the Access query to an Excel
file, there is an Auto Start argument which you can set to Yes to get
Excel to open the worksheet.
 
You must log in or register to reply here.

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

Similar Threads

Refresh and run Excel macro 7
Excel Data Transfer Issue (strange situation) 1
Issues when opening excel through access 10
Microsoft Jet Database Error 1
Export to Excel 3
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Calculate Totals in Spreadsheet 2
A2003 bringing in data from an Excel spreadsheet 1

Back
Top