Hi all,

I am facing a weird issue while automating a plugin for excel. when I am opening the excel using the following lines of codes:

SystemUtil.Run "excel path"
Set oExcel=GetObject(,"Excel.Application")
Set oBook=oExcel.WorkBooks(1)
Set oSheet=oBook.Sheets(1)


Set oExcel=CreateObject("Excel.Application")
Set oBook=oExcel.WorkBooks.Open(Excelpath)
Set oSheet=oBook.Sheets(1)

After the above lines of code are executed, I am writing a proprietary formula that refers to another cell in the same workbook, it is giving me #Name?

Whereas when I am doing the same operation after manually opening the excel file, the same formula is giving result.

Can anyone please point me in the right direction as to how to resolve this issue?