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

You have to break your code into two separate routines.

Open workbook and automatically run first code up to point where user intervention is required.
Allow user to do things. When done they will need to start the second part of the code.

You can make use of the before close event if the workbook is in a state to perform the second set of code.

How do you know the user has completed requried editing and is not just closing the file?