Quote Originally Posted by DarkF1ame View Post
js0873,

I constructed a little test and was able to get the address to change on my hyperlink using your code. I did obviously have to mess with the paths to make them specific to me but that shouldn't be a huge deal for you to fix. I would suggest finding where it's pointing now and pasting that string of text into windows explorer to make sure the link is properly formatted. When I stepped through the code (F8) the hLink.Address populated properly, double check the actual address that the hyperlink is pointing to (not just what is displayed) and verify it is entered correctly in the code. Secondarily I agree that the HYPERLINK function in Excel may be an easier way to construct your spreadsheet.

Hope this is helpful, if not please post again and we'll try to help.

DarkF1ame
I found my problem. The replace function had a typo, but the main thing with testing and seeing nothing was that I thought that this was only processing cells that had a hyperlink assigned ...

For Each hLink In wSheet.Hyperlinks

Instead it's processing all cells. I didn't realize that.