Unable write data into .xlsb file

Hi Team,

I have a web application where in after carrying out few steps an excel is generated in .xslb excel format.

While trying to use get object method to enter data in excel cells which are predefined the data entered is blank.

Below is the code and attached is the screenshot

sWebADIFilePath="C:\Users\uk1346\AppData\Local\Microsoft\Office\UnsavedFiles\Book1((Unsaved-306660471733269083)).xlsb"

Set objExcelbook2 = GetObject(sWebADIFilePath)

Set objExcelsheet2 = objExcelbook2.Worksheets(sWebADISheetName)

objExcelsheet2.Cells(8,5) = sLedgerJ

objExcelsheet2.Cells(9,5) = sCategoryJ

objExcelsheet2.Cells(10,5) = sCurrencyJ

objExcelsheet2.Cells(11,5) = sAccountingDateJ

objExcelsheet2.Cells(12,5) = sJournalName

objExcelsheet2.Cells(13,5) = sJournalDescriptionO6KBr.png

Hi,
From your screenshot, your code is referring to a different workbook. There is no way to tell if the variables have any value so we can't debug that.

I was talking about the workbook name. Your code specifies "C:\Users\uk1346\AppData\Local\Microsoft\Office\UnsavedFiles\Book1((Unsaved-306660471733269083)).xlsb" but your picture shows just an unsaved "Book1", which will have no path or file extension.