I have used the following code to open Access, export a table into an Excel spreadsheet, and close Access:
Dim ac As Access.Application
Set ac=New Access.Application
ac.OpenCurrentDatabase ("c:\reports.mdb"
ac.DoCmd.TransferSpreadsheet acExport, 8, "TEMP_STAT", "c:\moduletest.xls", False
ac.CloseCurrentDatabase
Is there a way to open Excel with the newly created spreadsheet?
Dim ac As Access.Application
Set ac=New Access.Application
ac.OpenCurrentDatabase ("c:\reports.mdb"
ac.DoCmd.TransferSpreadsheet acExport, 8, "TEMP_STAT", "c:\moduletest.xls", False
ac.CloseCurrentDatabase
Is there a way to open Excel with the newly created spreadsheet?