G
Guest
Guest
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
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