So I have a couple of hyperlinks that I'm trying to make, but these files have been named with a # sign in them. After a while of trial and error, I realized that they are whats keeping excel from correctly opening them. Shows the error of "Cannot open specified file", I'm guessing its because excel thinks its referencing to a sheet name. Does anyone know if there is a way to make excel open that hyperlink properly?( without changing the names of the original files)
Thank you very much!
Welcome to the forum.
Off the top of my head, I'd suggest using the CHAR number for # (35) rather than # in the link - perhaps you can try this?
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Thanks! Cool idea, I'll give it a try.
Doesnt work....
That's unfortunate. I've had a brief look on the internet, and could find no hits that referred to having a "#" as part of a hyperlink. Hopefully, somebody else on the forum will help you resolve this.
That's why I've come to the forums! Any halp from anyone is greatly appreciated. Hopefully I wont have to go back and rename those 9200 files...... Although I'm sure a VBA script will do the trick?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks