Hi.
I have this WB named SERIAL with the first column as serial number that looks like this "123-12, 124-12,.....", second i have this folder where every wb is saved with a serial number ex:"123-12".
Here is what i want:
1. I want a code to automatically create a hyperlink in the SERIAL wb in the first column to the file in this path "C:\Documents and Settings\user\Desktop\serial\2012"
thus i want to click on lets say serial number 115-12 in the serial wb and the wb 115-12 located in the above path will open.
I have almost 500 serial numbers so it will b very hard to create a hyperlink for each one.
thank you..
Bookmarks