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
Bookmarks