File A and File B Together
I have an excel file, File B (with macros), that is run during a month to
collect data. I have another excel file, File A (with macros), that runs at month end. File A opens File B and works with the data in File B. I need a way for the macros in File B to know whether it is running on its own or whether it has been opened by File A. The 'Public' statement Help says "variables declared using the Public statement are available to all procedures in all modules in all applications", but File B doesn't seem to pick up on a Public variable I have in File A. I have also tried having File B check to see if File A is open, but that always seems to come back true, even when File B is opened on its own. Any ideas would be appreciated. -- Bill @ UAMS |
File A and File B Together
If its a case of one or two books open, use:
MsgBox Application.Workbooks.Count -- Gary's Student "BillCPA" wrote: I have an excel file, File B (with macros), that is run during a month to collect data. I have another excel file, File A (with macros), that runs at month end. File A opens File B and works with the data in File B. I need a way for the macros in File B to know whether it is running on its own or whether it has been opened by File A. The 'Public' statement Help says "variables declared using the Public statement are available to all procedures in all modules in all applications", but File B doesn't seem to pick up on a Public variable I have in File A. I have also tried having File B check to see if File A is open, but that always seems to come back true, even when File B is opened on its own. Any ideas would be appreciated. -- Bill @ UAMS |
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com