Calling another worksheet
I need this Auto_Open() macro to open the document listed and it works fine,
my problem is that : 1. I do not want it to become the active document 2. The name of the document running this routine can change. Otherwise I would just add a statement to make C:/xxx.xls active. Sub Auto_Open() ' ' AutoRun Macro ' ' Workbooks.Open Filename:="O:\PT_DRIVER_SCHED\Templates\EmployeeLi st.xls" End Sub |
Calling another worksheet
Add:
thisworkbook.activate to get back to the workbook with the code. Patrick Simonds wrote: I need this Auto_Open() macro to open the document listed and it works fine, my problem is that : 1. I do not want it to become the active document 2. The name of the document running this routine can change. Otherwise I would just add a statement to make C:/xxx.xls active. Sub Auto_Open() ' ' AutoRun Macro ' ' Workbooks.Open Filename:="O:\PT_DRIVER_SCHED\Templates\EmployeeLi st.xls" End Sub -- Dave Peterson |
Calling another worksheet
Patrick, If the document you want to be active is the same as the
document containing the Auto_Open sub, put this line in your Auto_Open sub just before the End Sub line: ThisWorkbook.Activate James Patrick Simonds wrote: I need this Auto_Open() macro to open the document listed and it works fine, my problem is that : 1. I do not want it to become the active document 2. The name of the document running this routine can change. Otherwise I would just add a statement to make C:/xxx.xls active. Sub Auto_Open() ' ' AutoRun Macro ' ' Workbooks.Open Filename:="O:\PT_DRIVER_SCHED\Templates\EmployeeLi st.xls" End Sub |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com