object = win32com.client.Dispatch('Excel.Application')
object.visible=1
object.Run("Disability_Run")
print("Macro ran successfully!")
wbName=object.ActiveWorkbook.Name
absPath=os.path.abspath(wbName)

print("absPath=",absPath)
print("Active WB:", wbName)

for wb in object.Workbooks:
   print("WB:",wb.Name)
   wb.Save()
   #The loop above saves all the workbooks that are open

object.quit()

#Open the Excel file again

object=win32com.client.Dispatch('Excel.Application')
object.visible=1
wb1=object.Workbooks.open('C:\\Program Files\\SunGard\Prophet Excel Reporting\\Altsta_14b\\ExcelRPM.xlam')
wb2=object.Workbooks.open('C:\\Program Files\\SunGard\Prophet Excel Reporting\\Altsta_14b\\Perms.xlam')
wb3=object.Workbooks.open('C:\\Program Files\\SunGard\Prophet Excel Reporting\\Altsta_14b\\ProphetQueries.xlam')
object.RegisterXLL('C:\\Program Files\\SunGard\\Prophet Excel Reporting\\x86\\GleanExcelResults.xll')
#The above makes not receive the error message about the 'GleanReleaseComponentLocks' macro, because it imports the Prophet Add-in. However still not receive the prophet add in

wb=object.Workbooks.open(absPath)

wb=object.Workbooks.open(absPath)

Quote:Even though I do not receive any error message I am not able to open again the file with this line once has been closed.