Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
synchronisation beetween two excel instances
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non synchronisation in split screens in Microsoft Excel | Excel Discussion (Misc queries) | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions | |||
Beetween Sheets | Excel Worksheet Functions | |||
worksheet synchronisation and other one | Excel Programming | |||
Is there an easy way to replace list A instances with list B instances (sorted lists). | Excel Programming |