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

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.

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