opening excel after transferSpreadsheet (1 Viewer)

[shaggyjb]

I am using TransferSpreadsheet to export my table into a spreadsheet and this works fine, my problem is with opening the file from access. I figured this would work, i added a hyperlink on the button that also performs TransferSpreadsheet, but this does not work. Excel opens currupt. What is a good way to open the file i just made , or will the hyperlink work on the same button.

thanks

 

[Rob.Mills]

Check out the docmd.outputto in the help file. It will do the same function but also gives you an option to open the file.

 

[gmann]

DimExcelApp As Object
Dim strSaveFileName As String
Set ExcelApp = CreateObject("Excel.Application")
strSaveFileName= 'your file path and file name
With ExcelApp
.workbooks.Open strSaveFileName
.Visible = True