Vbscript - How to put path or SAS program name with spaces in between

sagulolo — Tue, 10 Mar 2020 04:03:03 GMT

Dear all,

I'm have successfully schedule my program with EG, plus I getting idea from https://communities.sas.com/t5/SAS-Enterprise-Guide/Running-SAS-EG-Projects-sequentially/td-p/342843 to schedule few project in a sequence that I want by amended the vbscript, please see below which the schedule job run without any issue(at least in my view the task is perform without issue)

From

prjName = "C:\Users\XXXXXX\Desktop\Project1.egp"    'Project Name

prjPaths = Array("C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT1.egp", "C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT2.egp")
For Each prjName in prjPaths

The only issue for me is i have project which the name have space or path with space, like

path = C:\Users\XXXXXX\Desktop\New Schedule

project name = PROJECT 1.egp

I have try to google but no luck and trying the code such as

"""C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 1.egp"""

"C:\Users\XXXXXX\Desktop\NewSchedule\""PROJECT 1.egp"""

Appreciated if you could guide/advise me the correct syntax to fix the above, thank you for your time and thank in advance.

Re: Vbscript - How to put path or SAS program name with spaces in between

sagulolo — Mon, 16 Mar 2020 09:37:37 GMT

Dear all,

Today i have tested the vbscript code below and it run without any issue, not sure why it failed at the begining.

prjPaths = Array("C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 1.egp", "C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 2.egp")
For Each prjName in prjPaths

Hope this help others.

Thanks for your time

topic Vbscript - How to put path or SAS program name with spaces in between in SAS Enterprise Guide

Vbscript - How to put path or SAS program name with spaces in between

Re: Vbscript - How to put path or SAS program name with spaces in between