Our company has an excel project list that has a column for "Job Number", "Job Name", "Job Description", etc...
I want to create a button (or a dialog box perhaps) that would allow the user to either type in the job number or click on the cell containing the job number and then have that job's folder open in windows explorer. I don't think there will be any user preference with either clicking or entering the number... so I guess whatever is easiest.
1) The project folder will either be located on our company's "X:\Projects\" or "Z:\Projects\" folders on our server. Both main folders also contain sub-folders for the job year (i.e. "X:\Projects\2010\" for "10-###" job numbers". Perhaps it would be nice to be able to select the drive from a drop-down list, and have the code identify the correct sub-folder using the first 2 digits of the job number.
2) The job numbers will not match the folder name exactly... BUT the folders do begin with the job number. Ex. Job #: "10-001" might have a project folder named "10-001 EE" or "10-001 Experts Exchange". Again, the "10-" designates the year and the remaining 3 digits designate the job number of that year. There will always be 3 digits to the right of the "-", never more, never less.