I have a class mod which contains the following code:
Does anyone know why my code falls over on the last line below:
Private oExcel As New Excel.Application
Set oExcel = Excel.Application
oExcel.Visible = True
oExcel.Calculation = xlCalculationAutomatic
I've got Excel referenced too so it's not that.
Sorry new to class mods...!
Does anyone know why my code falls over on the last line below:
Private oExcel As New Excel.Application
Set oExcel = Excel.Application
oExcel.Visible = True
oExcel.Calculation = xlCalculationAutomatic
I've got Excel referenced too so it's not that.
Sorry new to class mods...!