macro_man
01-25-2013, 03:33 PM
I have a workbook (we will call it workbook 2) that contains a report that is on a company network drive, viewed by various supervisors in the plant. I use a macro in another workbook (we will call it workbook 1) that updates information to workbook 2.
What I need is a way to invoke a macro located at workbook 2 after the macro at workbook 1 is completed (has updated the report at workbook 2). This cannot be an autorun macro because if the supervisors open the file I do not want the macro to run.
I'm looking for something simple that will tie macros together, located in different workbooks.
Thanks very much in advance for any assistance.
What I need is a way to invoke a macro located at workbook 2 after the macro at workbook 1 is completed (has updated the report at workbook 2). This cannot be an autorun macro because if the supervisors open the file I do not want the macro to run.
I'm looking for something simple that will tie macros together, located in different workbooks.
Thanks very much in advance for any assistance.