Hi,
I currently have a 'parts' spreadsheet, in column 'A' I have recorded all of the part codes. In a folder on my drive I have the drawings to all of these parts. What I want to do is hyperlink the drawings to the part code in column 'A' of the spreadsheet, there are over 300 parts to this so I was hoping there was a speedy way of doing this in VBA (note the drawings have the same file name as the code recorded in the spreadsheet)
Any ideas?
Thanks
Stevie B
I currently have a 'parts' spreadsheet, in column 'A' I have recorded all of the part codes. In a folder on my drive I have the drawings to all of these parts. What I want to do is hyperlink the drawings to the part code in column 'A' of the spreadsheet, there are over 300 parts to this so I was hoping there was a speedy way of doing this in VBA (note the drawings have the same file name as the code recorded in the spreadsheet)
Any ideas?
Thanks

Stevie B