Hi all,
I have an excel sheet with several incorrect hyperlink.
I would like to create a macro that:
- You press hyperlink on cell
- The address is passed to a macro
- The macro returns the correct address
- and jpg file is opened with correct link
example
hyperlink to "c:\OldFolder\image.jpg" ===> OldFolder doesn't exist
and macro return "c:\NewFolder\image.jpg" ===> that exists
The links are not sorted, they are scattered everywhere
How can I do?
thank you very much
for any suggestions
K.
How will the macro determine the correct address/link?
If posting code please use code tags, see here.
Hi Noire,
thks for the reply,
the macro should know the operating system.
If I use W7, return a string, If I use XP, return another.
thks
EDIT:
for instance in this way
https://msdn.microsoft.com/en-us/lib.../ff837365.aspx
Last edited by Keisy; 05-25-2016 at 09:56 AM.
For now, I used Worksheet_FollowHyperlink.
Within this:
- I take the name of the file
- I pass it to a custom function that is responsible to evaluate the operating system
- Return the correct path
- Replace the address with Application.ActiveCell.Hyperlinks (1) .Address = ......
However, I would like to replace hyperlink before it is launched.
because at the first click on hyperlink it takes the old address!
How can this be?
.. in practice I have to update the hyperlink address before the click is successful! This is my problem now..
thks
Last edited by Keisy; 05-25-2016 at 02:07 PM.
Hi,
maybe I solved it, but I have a problem.
When I try to open this macro in Calc I get error in this line:
obj = Application.OperatingSystem
How can I fix?
in Excel works fine!
thks
K.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks