Call Shell(explorer.exe & thePath, vbNormalFocus) opens the Windows folder
with pathname thePath.

My trouble is the folders I'm trying to open have a comma in their name, as:
thePath = "C:\My Documents\firstword, secondWord"

With that stinking comma in the path, Call Shell(explorer.exe & thePath,
vbNormalFocus) doesn't open the folder, it fails, and gives an alert: 'The
path 'secondWord' does not exist or is not a directory'.

Is there a fix? (There are thousands of folders, so taking the comma out of
the folder names isn't a practical option.)

GAKane


[oops I mistakenly posted this on someone else's thread. Sorry. Here it is
on it's own.]

Perhaps try putting in extra quotes around your path?

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"GAKane" <GAKane (AT) nospam (DOT) com> wrote