Log In
Register
Home
June 30, 2022
Offline
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
See Answer
October 5, 2010
Offline
Hi Michael,
It doesn't like the # in the folder name. It's not advised to use characters like # in file or folder names, can you change it?
Regards
Phil
June 30, 2022
Offline
Hey Phil,
Unfortunately I can't. The file is controlled by our IT department and they don't allow us to make changes to certain folders.
V/R
Michael
October 5, 2010
Offline
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
Offline
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
Offline
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)
