03-29-2014 10:44 AM
Can somebody tell me what is wrong with the code below? It wont run manually or with the task scheduler. It has worked in the past but stopped working for some reason.
Any help would be much appreciated.
If not (app Is Nothing) Then
Set app = Nothing
On Error Resume Next
prjName = "C:\My Data\ReportDocs_DRC_Daily_Sales\SAS_DailySales.egp"
Set app = WScript.CreateObject("SASEGObjectModel.Application.4.3")
Set prjObject = app.Open(prjName,"")
Set container = prjobject.ContainerCollection
For n=0 to (container.Count -1)
if container(n).ContainerType = 5 then
Set orderedList = container(n).Items
for p=0 to (orderedList.Count -1)
03-31-2014 08:40 AM
"Doesn't run" is pretty broad. Any specifics? I'm not a VB programmer, so I can't help on the specifics of the code.
In general, if something that used to run, stops running, I look for changes in the environment. Can you still run any scheduled tasks? Perhaps IT removed or restricted that capability for users. New OS? Other new software?
03-31-2014 02:27 PM
The script use to run on my old laptop with Windows 7 but recently upgraded to a new machine. The script opens the SAS query, closes and saves it but doesnt run the actually query. i can tell because the time on the query has changed. Could it be a system setting I need to change?
Any help would be great.
04-03-2014 12:18 PM
I have escalated this to the IT Folks as I think it could be an system setting on my laptop. I can run it on my old laptop no problem.
Thanks so much for your help.