synchronisation beetween two excel instances

[yoyovicks]

Hello

I am working on an application with two excel files.

In an excel file (file1) I execute one macro (macro1).
Firstly, macro1 must open another excel file (file2), once file2 is
open I want to suspend macro1 to give time to the user to make some
modifications on file2. When the modifications are done, the user will
press on a button and resume macro1.

The main problem seems to stop the code of file1 while I am working in
file2, and then coming back to file1 and continue with the execution of
macro1

I have some ideas about the solution:
- Using an ActiveX server
- Process synchronisation using WaitForSingleObject
- Mutex

Does anybody have an idea?

Thanks

 

[Harlan Grove]

Multiposted to comp.apps.spreadsheets (if not other newsgroups).
Answered there.

DON'T MULTIPOST.