PDA

View Full Version : PDF Tracker Help!



fm2340562
04-09-2012, 06:43 PM
Hi,

I am New to VBA and I need help in creating a spreadsheet that tracks PDF's

When a PDF is Created it is saved as the drawings Item Number followed by the revision letter eg. "8400023A"

These are all saved in a folder called eg. "J:\0.1 - Released PDFs"

The Revision Colum’s are as follows;

Col E = Rev A
Col F = Rev B
Col G = Rev C
Col H = Rev D
Col I = Rev E
Col J = Rev F

The Item numbers are located in the following range;
D5 : D190

For each item number I want it to look in the folder and if there is a revision letter put a link with the correct letter in the appropriate column.

I have spent about 3 hours playing around and getting nowhere so I’m reaching out of the help of experts; Thanks in Advance!

Joel

lynnnow
11-02-2012, 12:32 AM
For each item number I want it to look in the folder and if there is a revision letter put a link with the correct letter in the appropriate column.


Does this mean that the original file, plus the revisions are also going to be available in the folder?