hyperlink open folder in desktop

[hongkongtomlam]

Dear All,

Please help attached with vba code, could u please help me how vba code work
because i try many times and cannot work

the vba code can make hyperlink so i can do as follows

that is ,
if i click ABC in A1 , then it will open file named 1 in folder named 2011 ( c1) in desktop
if i click ABC in A2 , then it will open file named 2 in folder named 2011 (c2) in desktop
if i click ABC in A3, then it will open file named 11 in folder named 2011 (c3) in desktop
if i click ABC in A4, then it will open file named 100 in folder named 2012 (c4) in desktop

Thanks
Tom

[Squeaky]

Hi hongkongtomlam, Not sure you need to use VBA for this. In your document, select ABC, then right click and select link. Under Link to: make sure Existing File or Web Page is selected, then go find the file. Once you select the file, ABC will become a link to that document and will open it when selected.

Squeaky.