Code Checking if workbook is open, is not working

[jazbath]

Hi,

Here is the code:

Each time I run my code and if DB.xls is open it halts the code.

Thanks for your help.
Jaz

[shg]

If the activeworkbook is DB.xls, there's no need to activaate it. Do you want to know if it's among the open workbooks?

[jazbath]

If the activeworkbook is DB.xls, there's no need to activaate it. Do you want to know if it's among the open workbooks?

I would be adding data to it, so I just don't want to know but activate if its open and add data. If its not open then open it.
Thank you Shg
Jaz

[Leith Ross]

Hello jazbath,

I am not sure if this is what you are after. This code will test if the file open is open or not. This code can also be used for testing if the file has been opened in a separate instance of Excel (Code from Microsoft article KB213383)

Please Login or Register  to view this content.

[jazbath]

Hello jazbath,

I am not sure if this is what you are after. This code will test if the file open is open or not. This code can also be used for testing if the file has been opened in a separate instance of Excel (Code from Microsoft article KB213383)

Please Login or Register  to view this content.

Hi Leith,
thanks for posting the code. I am not looking for something like this. I am running a code to collect data from a run sheet and put into DB.xls. So if DB.xls is already open I am trying to have the code just select DB. If not open DB.xls to input data.
Thank you
Jaz

[Leith Ross]

Hello jazbath,

Will you be in Excel when you do this check for DB.xls?

[jazbath]

Hello jazbath,

Will you be in Excel when you do this check for DB.xls?

Yes Leith. Because the data I am collecting is on an Excel sheet.
thanks Jaz

[Leith Ross]

Hello jazbath,

Sorry for the delay. My wife came home late and we finished dinner. This will set the object variable Wkb to the workbook "DB.xls". If the workbook isn't open then the macro will open it. This assumes "DB.xls" is in current directory. If it is located elsewhere, you need to add the folder path to the file name to open it.

Please Login or Register  to view this content.

[jazbath]

Leith,
Thank you for the code. That solved the problem.
Sincerely
Jaz