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

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

--

Dave Peterson

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