The Missing File

B

Bootney

Joined
Jul 24, 2005
Messages
1
Reaction score
0
I have a finance folder inside over 3000 multiple folders increment i.e.. 10020-Inv, 10021-Inv, etc..
Each folder must have an invoice with folder reference 10021-inv.doc. 10021-inv.doc

so..

Folder name ..... Invoice inside
10020-Inv....... 10020-inv.doc
10021-Inv....... 10021-inv.doc
10022-Inv
10023-Inv .......10023-inv.doc

Folder 10022-Inv has NO Invoice inside folder

I need a VBA routine to search inside the Finance folder and subfolders
And list which folders are missing invoice docs
With folder name, and hyperlink folder location list on a spreadsheet.

Any advice...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA HELP! MsgBox & File & Sumif ****** 5
Create folder, text file and vbs script from data in excel 5
Hyperlink to a folder 2
Sort cells and "Place in this document"-hyperlinks 1
SUM in VBA, Msgbox 3
File exists but cannot open from Excel 4
Cell contents in a word doc 1
FSO.MoveFile 9

Top