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
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