Trying to save my Excel 2007 has an xml file. When I do a "Save As" I select xml -- then I get a warning saying "Cannot save XML data because the workbook does not contain any XML mappings."
Basically what I want to do a search and replace of hyperlinks.
For example, My hyperlink would be http://www.bananas.com/apples.html
And I want to change it to
I googled hyperlink search and replace and was told one method is to save as hyperlink and then open in notepad or similar and do the search and replace there.
However as I write this question, perhaps there is an easier way to do it? Perhaps with a visual basic script????
Or a formula?
I'm getting an error with 5teveo's version (perhaps I copied and pasted it wrong. (Subscript out of range.)
And Angelplay is also changing the text of the hyperlink. I need to keep the visible text untouched.
I should have uploaded a sample file. The attached includes both vb solutions.
Thanks for helping!