Error 1004 'cannot access file'

[ingineu]

I am working on a project that involves the following steps:

1. Open Workbook1.
2. Capture Oracle data into a Sheet ("Data") in a new workbook, Workbook2. I use ADO. This is working.
3. Match the new sheet, "Data", with an existing sheet in Workbook1 ("Categories") and output the merged data into a new sheet in Workbook2. I use JET to accomplish reading Sheet ("Data"). I come up with error 1004 'cannot access file ..../xls'.

I started out just using 1 workbook, but then it always tried opening another instance of Workbook1 when it encountered the Jet connection Open command. Any ideas how I would best accomplish merging data from 2 different connections.
Thanks

[Leith Ross]

Hello Ingineu,

ADO can only work with one connection at a time, hence your error. I am not sure why in your case, you need 2 connections. You will have to close one connection before you open the other.

Sincerely,
Leith Ross

[ingineu]

I do close the first connection before opening the second one. I Found a way to get around the issue ... just before I open the new connection, I save Workbook2.