Macro to Open hyperlink

[melleniam]

Hi,

i have list of link in my excel sheet such as

S:\Statements\ABC.txt

i need a macro to open these link, because whenever i click on the link, it opens a new Excel and i can't do the links

thanks

[ragulduy]

You can "click" a hyperlink in VBA like this:

Please Login or Register  to view this content.

[melleniam]

hi thx however the code didn't work, it only worked with weblinks "http:// etc."

[ragulduy]

What type of file are you trying to open? I can open .txt and .pdf etc with the follow command. Will it always be the same type of file? If so you could get the address property of the hyperlink and then use the program to open it or a shell command or something.

[melleniam]

Actually I’m recording, so in the process i want excel to open 10 text files in my drive, the path/links of the files are A1:A10, i hyperlinked the path by the hyperlink formula and recorded the opening one by one, however it opened them in separate excel, so i couldn’t link the values.

and still the code you provided couldn't open the files

[ragulduy]

Can you upload a sample of the workbook with the links and the code you have to open in separate excel? For me, if I click a hyperlink to a text file it opens it in notepad, I don't understand exactly what it is that you are doing..