VBA Code to find a Folder name within a Parent folder that contains defined text

Hello,
I've searched the forum and found numerous variations of my problem but none solve my problem exactly.
And with the numerous variation of answers, I haven't a clue where to begin.
Basically, I have an Excel VBA Macro for creating/logging drawing numbers.
Each drawing belongs to a job number.
Each job number has a folder name containing the job number followed by a description (ie 999999 - bracket assembly) for storing drawing pdf's.
The job number is only known as a 6 figure number in the drawing creation process BUT for the PDF saving process it is a string value...as my example above

I have to change my process by pre-creating the Job Number folder, then have the macro look for the appropriate folder by searching the parent folder for a sub folder containing the job number (always the first 6 figures).

There are a number of threads that touch on my problem but none actually solve it. It's best i start this thread from scratch cos I haven't a clue how to put a starting code in this thread...there are that many different ways...and I have no clue which method is the best.

I want to insert in my macro some code that searches...

The parent folder for a folder containing the job number.
The macro value for the parent folder is P:\engineering\drawings\ (this never changes).
the macro value for the job number is iOpenair (it's an entry that is entered as start the macro).
Imagine the value for the job number is "999999"...so the search would be for "999999*.*"
The code needs to search the parent folder, find the folder name that begins with a six digit number. Capture the complete name of the folder and store that name as a Dim value that I can call up elsewhere in my macro.

any and all help is much appreciated cos I've given up.

regards

gary

Cheers for the welcome...
I think I've scoured this website for a complete day...putting things together and trying things out with no success...
my brain's full of tried, tested and failed ways of doing things now!
anyways...thanks for my starter for 10...
unfortunately it errors at fso with variable undefined...
i've tried changing it...but not knowing what it's doing, I'm failing.

cheers

Gary

Please Login or Register  to view this content.

Cheers...I'll try it in the morning.
Regards
Gary

Is there a setting to say that this thread is solved?

hi there, as per Forum Rules:

If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Solved...and marked as Solved.