Yesterday i created a hyperlink that would open another excel file and it worked fine. Today I added two more hyperlinks and they wont work an d neither will the one i created yesterday. It just says excel cannot open that file. Any suggestions?
Yesterday i created a hyperlink that would open another excel file and it worked fine. Today I added two more hyperlinks and they wont work an d neither will the one i created yesterday. It just says excel cannot open that file. Any suggestions?
Last edited by CityInspector; 10-19-2012 at 01:15 PM.
Please upload the sample file.
Were the hyperlinks created by macro or manually?
Did you change the location of the files?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I used the create hyperlink option when you right click on the cell.
They were moved but i deleted that hyperlink and added a new one with the new location. still doesnt work.
If you upload a sample file, it will help to troubleshoot.
I will try. let me know if that works.
Inspected items.xlsm
So where should the hyperlinks be placed? Should i just create dummy files like Book1.xlsx, Book2.xlsx and hyperlink them to your file?
I created a hyperlink myself and it worked. Could you try again and ensure that you do not change the location of the file?
I figured it out. The folder that the workbooks were in had a "#" in the name. When I removed that everything works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks