code to return to active workbook

I am using code to open another workbook from an open workbook.
In the workbook "SheetChange"module I have:
Workbooks.Open Filename:="P:trial5.xls"
works fine...

After I update the ("Trial5") workbook, and close it, I get an EXE crash. I think I need to write the code to return and activate the original workbook ("PSFDB2"), but I dont know the code.

Workbook.activate filename:="P:PSFDB.xls"....won't work

Thanks
Wrecker

[Barrie Davidson]

On 2002-03-08 06:13, Anonymous wrote:
I am using code to open another workbook from an open workbook.
In the workbook "SheetChange"module I have:
Workbooks.Open Filename:="P:trial5.xls"
works fine...

After I update the ("Trial5") workbook, and close it, I get an EXE crash. I think I need to write the code to return and activate the original workbook ("PSFDB2"), but I dont know the code.

Workbook.activate filename:="P:PSFDB.xls"....won't work

Thanks
Wrecker

Since your workbook is already open you don't need the path in your file name. This will work also:

Workbooks("PSFDB.xls").Activate

I'm curious if this will solve your problem. Please let me know if it does.

Regards,

[Wrecker]

Thanks.it worked fine

Wrecker