P
Patrick Simonds
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\EmployeeList.xls"
End Sub
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\EmployeeList.xls"
End Sub