Opening files using Open Text Enterprise Connect VBA library

Hello all just joined - 1st post

I've been using macros in Excel files held in EDRMS/ Opentext for some years which basically go to - via "Workbooks.Open Filename ........ " etc - open other Excel files kept in Opentext to copy data from & paste it into my original file containing the macro, for further manipulation.

We've had a recent upgrade to Opentext and "Workbooks.Open Filename ..... " no longer works and we've been advised to use a different method to open the other file, as follows -

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer


- the above breaks & displays the end/ debug dialog box on screen when it executes "oitem.open". "Workbooks(2).Activate" is highlighted in yellow. As soon as I press debug the new file opens and the macro can be restarted with F5.

Any advice on how to resolve this gratefully received. Thanks in advance.

What is the error number and error message?

I have clarified the title just a bit.

Yes, there is no second workbook open at the time this line is executed. I am not familiar with that particular API but generally a sub call is synchronous--it should not return until the file is open. (The exception to that are things like OS calls that run an external process.)

EDIT: This is a wild guess but maybe try a delay. This one waits 5 seconds:

Please Login or Register  to view this content.

I am curious as to why Workbooks.Open would not work. A workbook is a workbook. Are the workbooks not in the Windows file system?