Hi,
I have used these lines:
Set eap = CreateObject("Excel.Application")
eap.Visible = True
Set ewb = eap.Workbooks.Open("Eudims07PMPackagePMProgramS.xls")
ewb.activate
to open a workbook from another one. This works fine the first time. However once the workbook has been opened and closed (the workbook, not the excel program) This line won't re-open the workbook.
Does anyone know how to deal with this?
Cheers
Ed
This message was edited by Jackeb on 2002-04-29 02:03
I have used these lines:
Set eap = CreateObject("Excel.Application")
eap.Visible = True
Set ewb = eap.Workbooks.Open("Eudims07PMPackagePMProgramS.xls")
ewb.activate
to open a workbook from another one. This works fine the first time. However once the workbook has been opened and closed (the workbook, not the excel program) This line won't re-open the workbook.
Does anyone know how to deal with this?
Cheers
Ed
This message was edited by Jackeb on 2002-04-29 02:03