Macro

P

Pam Coleman

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,
 
S

Steve Schapel

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.
 
Top