Hi All,
Am a complete VBA newbie and have totally jumped into the deep end with a work project. I have a wokbook that records an individual id number for each job that i log in Column J. A copy of this is saved on my computer in the File "CAP TEST". What i need is a macro that will automatically search "CAP TEST" find the job id and create a hyperlink from that file to the workbook which is acting as a database.
I think that the code below will do what i want but i keep getting an error 52 'Bad Filename or number' and i'm not sure how to fix it. The job id id in the form ABC-DEF-HIJ-0123, could this be the issue?
Am happy to send sheet through if this will help?
Many Thanks
Bookmarks