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

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