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#helixFSRSWarehouseWarehouseWarehouseEquipment_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
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
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
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:FSRSWarehouseWarehouseWarehouseEquipment_by_Platform
Incidentally, why are there 3 folders all called Warehouse???
Regards
Phil
Can you try:
ActiveWorkbook.FollowHyperlink Address:= Application.WorksheetFunction.EncodeURL("\bradford#helixFSRSWarehouseWarehouseWarehouseEquipment_by_Platform")
Or:
ActiveWorkbook.FollowHyperlink Address:= Replace("\bradford#helixFSRSWarehouseWarehouseWarehouseEquipment_by_Platform","#","%23")
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
Catalin,
Thank you very much!! I tried the first line of code and it worked!!
V/R
Michael
