KNOWLEDGEBASE - ARTICLE #175
How can I run a Prism script when there are spaces in the path name?
Prism gets confused if the SetPath command has a path with spaces:
But Prism works fine if you enclose the path in quotation marks:
If you are using VBA to generate the script, then use double quotes like this:
Print #1, "SetPath ""C:\My documents"" "
The outer set of quotation marks tell VBA to write out the enclosed text. The double quotes tell VBA to write out a single quotation mark but not keep writing. Note there are three quotation marks at the end, two to denote the one that VBA should write out to generate the script, and one that tells VBA to stop writing.