vbs script that checks if excel is already running and wait for it to be closed

Hi,

I am writing a vbs that is supposed to check if excel is running and wait until it is closed before executing a specific task.

Code:

Please Login or Register  to view this content.

However, even if the running instance of Excel is closed while this script is running, the script continues its loop thinking that excel is still running, as if myExcelWorker does not get updated with the new info at Set myExcelWorker = GetObject(, "Excel.Application")

Any idea, how can I fix this?

thanks