Runtime Error when opening and closing Excel Spreadsheet continuously

Hi.

Try not to recreate new connection to Excel everytime you need it.

You may create it once and assign to global (project) variable.

e.g.:

'do it once in your project

set Project.Variables.xlobj= Sys.OleObject("Excel.Application")

Set workbookObj=Project.Variables.xlobj.Workbooks.Open(Project.Path + "\Data_Input\Data_Input.xlsx")

[ some code]

Project.Variables.xlobj.WorkbookObj.Close()

'close workbook but don't "close" Excel itself (project variable which keeps connection still valid, you may reuse it for another workbook processing)

I use similar approach in my projects, I generate hundreds of workbooks without single issue.

Sorry if I've made mistakes in VBS syntax, I use JS.