Hi
I am using Access2013
I have code that appears in various on line pages trying to transfer data to an Excel spreadsheet...this works, but the code to open the spreadsheet does not!
Here is the code:
Private Sub cmdToExcel_Click()
'Transfer data to the spreadsheet
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryCRMOverviewSectionsRF", "C:\WirelessComponents\Spreadsheets\Transfer.xlsx" , True
'Open the Spreadsheet
Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open "C:\WirelessComponents\Spreadsheets\Transfer.x lsx"
xlTmp.Visible = True
End Sub
I seem to be missing a Microsoft addin but cannot see how to obtain and load it.
Help appreciated.. still learning
Thanks Bob