re-opening a new workbook

[Jackeb]

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

 

[Nibbles]

Hi,

Not sure why that is happening, though hopeully this may be of some use to you. I always open workbooks through VBA with the following code:

Sub open_workbook()
Workbooks.Open ("C:WINNTDesktopBook1.xls")
End Sub

I have never had a problem with reopening workbooks using this method.

Nibbs

 

[Jackeb]

cheers...

it has got me too.... rather i guess it is catching the file somewhere and the code thinks that it is already open?

Ed

 

[Nibbles]

That sounds likely. If you do use the code I suggested it will just reopen the file each time - if you have made changes and not saved, it will warn you that they will be discarded and give you an option to cancel.