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!
Macro open path defined in spreadsheet cell "A1"
Macro open path defined in spreadsheet cell "A1"
OpenOffice 3.1 on Windows Vista
Re: Macro open path defined in spreadsheet cell "A1"
Please upload sample files here.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.
And please update your signature in this forum. Which version of the AOO or LO are you using really?___________________________________________
OpenOffice 3.1 on Windows Vista
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.