• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to open a directory which contains a special symbol

Carley

New Member
Hoping that someone can assist me,


I need to open a new windows explorer with a path that contains an equals symbol.


Code I have is


x = Shell("explorer /n,/e,group.netglobalCroydonBroker2013= Broker Complaints", 1)


when I put this in my personal folders open instead.


If I take out the 13= Broker Complaints then the folder opens to the relevent drive.
 
Hi Carley,

There are spaces in the folder name so:

[pre]
Code:
x = Shell("explorer /n,/e,""group.netglobalCroydonBroker2013= Broker Complaints""", 1)
[/pre]
 
Back
Top