Macro open path defined in spreadsheet cell "A1"

[pablograf]

i have in line 1, A1 is a clickable hyperlink made from the path defined in K1.
with a macro i insert a new line copyed from another sheet abobe this first line 1. with the result of the hyperlink A1 and path K1 beeing different everytime.
so what i would like to do is to get the referenced file (*.s2s files, wich open automatically with the songs to see player) opened automatically with the macro, instead of clicking the hyperlink A1.
i have been searching for weeks for a solution, to no avail. i have to add that the few macros that i am running were recorded and then played around untill working. what i am trying to say, if someone has a solution for me, please assume i can bearly read and write please make it simple. thanks in advance!

[Zizi64]

i have in line 1, A1 is a clickable hyperlink made from the path defined in K1.
with a macro i insert a new line copyed from another sheet abobe this first line 1. with the result of the hyperlink A1 and path K1 beeing different everytime.
so what i would like to do is to get the referenced file (*.s2s files, wich open automatically with the songs to see player) opened automatically with the macro, instead of clicking the hyperlink A1.

Please upload sample files here.

___________________________________________
OpenOffice 3.1 on Windows Vista

And please update your signature in this forum. Which version of the AOO or LO are you using really?