Trying to open excel file from Access - User defined error

[forrestgump]

HI there,

I am trying to open an excel file from MS Access in MS Excel so I can add some vba to remove the top 3 rows of the excel sheet. However, with the code below I keep getting a "User Defined Type Not Defined" error on the first line of the code. How can I stop this so the code will run?

 Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Application
xlApp.Workbooks.Open "C:\Users\smithj01\Documents\smithltd\FilefromProduction\002_BankDetails_VBATEST.csv"
xlTmp.Visible = True

Any help will be greatly appreciated.

Kind regards,

forrestgump

 

[JHB]

You've the wrong reference, (wrong name):

Set [B][COLOR=Red]xlTmp[/COLOR][/B] = New Excel.Application [B][COLOR=Red]
xlApp[/COLOR][/B].Workbooks.Open "C:\Users\smithj01\Documents\smithltd\FilefromProduction\002_BankDetails_VBATEST.csv"

 

[pbaldy]

You're using early binding, which requires the Excel reference be checked in Tools/References.