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
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