

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


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)
