Forum Discussion

guna's avatar
guna
New Contributor
3 years ago

object required error

Hi all,  I am upgrading from 14 to 15 version recently. I am unable to get it this one, some times the code is executing successfully and sometimes getting Object required error, below one is the co...
rraghvani's avatar
rraghvani
Champion Level 3
3 years ago

My VBScript is not very good, but I'm able to write the following code to launch and open the Excel file

 

Sub Test1()
    Dim Excel, Filename
    Filename = "C:\Temp\Book1.xlsm"
    Set Excel = Sys.OleObject("Excel.Application")
    Excel.Visible = True
    Excel.Workbooks.Open(Filename)
    Excel.Quit
End Sub

 

Ensure you have Excel installed, and that the user has correct permissions. Also, ensure that the filename follows the Universal Naming Convention, i.e. "C:\Temp\Book1.xlsm" is different to this "C:\\Temp\\Book1.xlsm"