Comma is Stopping My Shell("explorer.exe") Call

I have created an add-in that does several tasks for our staff accountants. The problem I am having is in one of the userform buttons. The task is to view the current month's folder where the individual reports reside for the current financial package. I have replaced variables in my code example with typical values. The following procedure retuns an error that includes the path after the comma in DeSoto Ranch..., Inc. Basically, the code ignores the path before the comma. The commas are used in the name of the read-only folders on our network drive. Not all names have commas, and those properties do not return errors when the button is pushed. One solution is to ask IT to change the names. (I am a staff accountant and not a full time developer), but the challenge is too intriguing. There must be a way (my Excel VBA battelcry). Another solution is to create (with code) a shape with a hyperlink to open the folder. I have created a text link (with VBA), but it's not aesthetic. I can create a shape button/link without VBA, but it doesn't replicate for our 180 clients.

Here is the code for the Distribution Folder button on my userform that returns an error whenever the property name has a comma:

Please Login or Register  to view this content.

This is my first post, so I hope I have included the right info and not too much background.

Thanks,

Donn

I think you'll need to enclose the str_folder bit in double quotation marks:

Please Login or Register  to view this content.