Missing Library??

[TamworthBob]

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

[Welshgasman]

Add the excel library in Tools/References

[moke123]

As Gasman correctly points out, your error is due to a missing reference. Make a good mental note of it, as it's one you'll encounter from time to time.
This is especially true if trying out various code copied and pasted. The code you're using is early bound which requires a reference.

Mike Wolfe has a good article to explain what that is https://nolongerset.com/early-binding-vs-late-binding/

[TamworthBob]

Thanks Welshgasman
Problem is in my year of Access there is no "Tools/References" see below
???????
Thanks again
Bob

[isladogs]

Its part of the VB Editor menu in all versions of Access from A95 onwards including 2010

[moke123]

It's in the VBE.