Hi
I'm putting a macro in personal.xls so that I can run it on workbooks that are sent to me from external sources.
I need to get it to open a workbook "OMSREPORT.xls" and then make the original workbook the active workbook again so that I can continue working on it.
How do i either:
a) Open OMSREPORT.xls without making it the active workbook, or
b) get the macro to switch focus to the original workbook once OMSREPORT.xls is opened.
And, seeing as i'm here, is it possible to get the code to look at what workbook was the active one when the macro was executed, and if it is OMSREPORT.xls then stop it from running (it will damage the format/layout of OMSREPORT.xls if it is run on it)
Thx in advance
I'm putting a macro in personal.xls so that I can run it on workbooks that are sent to me from external sources.
I need to get it to open a workbook "OMSREPORT.xls" and then make the original workbook the active workbook again so that I can continue working on it.
How do i either:
a) Open OMSREPORT.xls without making it the active workbook, or
b) get the macro to switch focus to the original workbook once OMSREPORT.xls is opened.
And, seeing as i'm here, is it possible to get the code to look at what workbook was the active one when the macro was executed, and if it is OMSREPORT.xls then stop it from running (it will damage the format/layout of OMSREPORT.xls if it is run on it)
Thx in advance