Disabling Events
If Personal.xls is causing a problem when another workbook is opened (I'm
taking your word that it is so) then close it.
Set xLApp = CreateObject("Excel.Application")
xLApp.Workbooks("Personal.xls").Close, False
xLApp.Workbooks.Open FileName:=xLPath + "\" + xLFileName
--
Jim Rech
Excel MVP
|