Hi Everyone,

I really appreciate your help. Thanks in advance.

I have a list of accounts in a workbook. There should be a file on the
network for each account.

I have programmed Excel to consolidate all of the files into a master
workbook. This works fine, but before I run the consolidation macro, I want
to make sure that our staff has saved all of the files are on the network.
If the account is not on the network, then advise the user that "all account
reports have not been submitted. Please save all reports to the network and
then run the macro again". Close the macro. If all the files are there, run
the macro.

Network Path = W:\Budget Monitoring\IMJ\
IMJ is a Division

The Account List is saved as
W:\Budget Monitoring\"'Account List.xls'!IMJ"

List Ex.
70435
70372
70542

This is really simplified. I've got 27 divisions and about 200 accounts.

Thanks!