In my new office, they've named numerous folders on the shared drive using the special character "#." They'd like a central spreadsheet that includes hyperlinks to several documents in shared directories but in Excel 2003 (and prior versions?) any hyperlink that you create that contains this special character won't work! Ugh!!!
I don't think the office is willing to rename the numerous files with this special character for this sake.
(Oddly enough, I can create hyperlinks in Outlook to files in these folders.)
Anyway, my research in this forum and elsewhere hasn't uncovered any solution. Mainly, I'm seeing only posts regarding a link with a special character in another file name, but this is NOT what I'm talking about here (though similar. Again, this involves folders or subfolders with a special character.
I'm looking for a solution. My only though regarding a work around would be to have a macro or VBA code that would capture the contents of a cell (which would contain the non-functioning hyperlink), run File, and Open, paste that text into the file path field, and open the other file (Word, Excel, PowerPoint, etc.) I've record a macro to do this but of course it incorporates the actual text from my test cell. I understand I need to use a variable but I'm not familiar with VBA in Excel.
Can anyone help develop this assumed to be short and simple VBA code that I can put