In VBA Check if a Workbook is Open

[JillClaus]

I'm using Excel 97.

I wrote some VBA code that loops through all of the workbooks in a specified subdirectory and popolates each of them with data from a MS Access 97 database. It works well, but I'm stuck on one thing....

How can I check to see if a specific workbook is currently open (or closed)?

Any help would be greatly appreciated.

Thanks,
Jill

 

[Stang1993]

Just had 2013 pushed to me, what I am finding now is that when running my code it seems to "go to fast" which causes excel to fail. I was looking for something to slow it down, thinking I could use IfWorkbookOpen..... I am not having any luck with this. Is there something else I need to be doing in between opening a workbook then closing it and opening another one? Keep in mind the workbooks are all unique in that they have a name ex. Thomas.xls and so on. I am just trying to create a pause to hopefully let each one open and close without issue