Thread: Check if a folder has x files in it.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Check if a folder has x files in it.
Hi Everyone,

I am trying to do the following.

I have a folder e.g. C:\Folder1

I have this path defined as folderPath1.

I want to run a macro that will check that Folder1 has 24 files in it. If
not, a message box will display, prompting the user to check the folder again.

Can anyone help?

Thanks
Dave
Reply With QuoteReply With Quote