June 30, 2022
I created a button that I want to use to open a folder that is located in a network. Here is the code that I am using:
ActiveWorkbook.FollowHyperlink Address:="\\bradford\#helix\FSRS\Warehouse\Warehouse\Warehouse\Equipment_by_Platform"
When I click on the button, it is only opening the first folder listed in the path. What do I have to do to get it to open the last sub folder in the address?
V/R
Michael
October 5, 2010
Hi Michael,
Your IT Dept really should know better than to use characters like # in folder names. Can you ask them to change it?
Or, can you map a drive (e.g. D:) to \\bradford\#helix then your VBA would only need to open D:\FSRS\Warehouse\Warehouse\Warehouse\Equipment_by_Platform
Incidentally, why are there 3 folders all called Warehouse???
Regards
Phil
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Can you try:
ActiveWorkbook.FollowHyperlink Address:= Application.WorksheetFunction.EncodeURL("\\bradford\#helix\FSRS\Warehouse\Warehouse\Warehouse\Equipment_by_Platform")
Or:
ActiveWorkbook.FollowHyperlink Address:= Replace("\\bradford\#helix\FSRS\Warehouse\Warehouse\Warehouse\Equipment_by_Platform","#","%23")
June 30, 2022
Phil,
Our IT department is in another state and are very hard to work with. The gentleman that we have onsite will do very little for you and moves at a snails pace when it comes to getting anything done. The reason I have so many folders that say "warehouse", is because I started this project on my computer and once I was at a point I was ready to start consolidating and assigning links to folders, I moved it on to the network, I buried it under a few folders to keep others out of it, until I am ready to let it go live.
V/R
Michael
Answers Post
1 Guest(s)