I am using code like the attached to open workbooks in Excel. I am then parsing through a text file and then writing the data into the excel workbook. Problem is, I want to have several workbooks open at the same time and just switch the active workbook for writing.
Keep in mind that this is a VB Script, not VBA inside Excel.
Set objExcel = CreateObject("Excel.Application")
objExcel.WorkBooks.Open fnSO5Workbook 'variable pointing to workbook
Set objSheet = objExcel.ActiveWorkbook.Worksheets("2008 Detail")