Edit File Manually while Macro is running.

Hi All,

I am opening an excel file( say Test.xls), editing it and then closing it through a macro.

The problem is that i have to pause a macro untill I complete the editing in Test.xls and close this file, and then continue with the remaining code written in the macro.

I cannot use onTime or sleep as I have no idea how much time will the user take to edit the file.

Please help as I am stuck with this from past 2 days.

Thanks for the help.

Ankit