mdbct
Valued Forum Contributor

Hi there,
I used the vba code from a response you provided here: http://www.excelforum.com/excel-gene...e-changes.html and it worked great, but i opened up my spreadsheet today and it is no longer working. Can you please, please help me?

hi there mdbct,

I noticed your very helpful in helping those who don't know very much find a solution to their excel problem. My problem is that I have to save an .xls file to a .csv file, thus losing the hyperlinking power once i do this. So for example, if there was a link that says "CLICK HERE" and it goes to "www.google.com" all that would be saved on the .csv is the "CLICK HERE". What I would like assistance in is converting all the hyperlinks to the full <HREF= code. So for example, if the hyperlink reads "Executive Assistant" and the hyperlink is to go to another page when clicked then I would like that cell to change to;
<a href="https://www.xyz.com" target="_blank">Executive Assistant </a>

So this would ensure that prior to saving to a .csv I have the code. So when i open the .csv the HTML code is right there in plain text.

Again, I respect your excel knowledge and would greatly appreciate your assistance in this.

Thank you, thank you! Your a genius! You have no idea how mmnay nights of sleep I've lost over this. thank you so much!

I would very much appreciate your help if you can with this checkbox stuff

Thank you for your help!