I have several process flows in this project.  I was simply trying to use the copy/paste feature that was created for EG 7.1 rather than having to save an entire copy of the project over another.  My projects are heavily documented and organized so cross training is not an issue. ... View more

So I looked at that example and it looks a bit different than the vbs file generated by EG when I created a schedule.  Again, I have not programmed in vbs much at all.  I like the option of the lest rich UI for the user if possible, I just want them to be able to enter a date as a variable I created in the prompt manager inside EG (i.e. START_DATE).  Here is the vbs code that was generated by EG when I scheduled it.  Trying to determine how I would modify it according to the example you linked to.   Option Explicit Dim app ' As SASEGuide.Application Call dowork 'shut down the app If not (app Is Nothing) Then app.Quit Set app = Nothing End If Sub dowork() On Error Resume Next '---- ' Start up Enterprise Guide using the project name '---- Dim prjName ' As String Dim prjObject ' As SASEGuide.Project Dim containerName ' As String Dim containerObject ' As SASEGuide.Container Dim containerColl ' As SASEGuide.ContainerCollection prjName = "L:\MSR SAS Project Development\MASTER DEVELOPMENT FOLDER\Automation\SAS EG Project Automation\SAS EG Automation Projects.egp" ' Project Name containerName = "MSR0023 - ALM Bi-Monthly Pipeline Report" ' Container Name Set app = CreateObject("SASEGObjectModel.Application.7.1") If Checkerror("CreateObject") = True Then Exit Sub End If Set prjObject = app.Open(prjName,"") If Checkerror("App.Open") = True Then Exit Sub End If '----- 'Get The Container Collection and Object '----- Set containerColl = prjObject.ContainerCollection If Checkerror("Project.ContainerCollection") = True Then Exit Sub End If Dim i ' As Long Dim count ' As Long count = containerColl.count For i = 0 To count - 1 Set containerObject = containerColl.Item(i) If Checkerror("ContainerCollection.Item") = True Then Exit Sub End If If (containerObject.Name = containerName) Then Exit For Else Set containerObject = Nothing End If Next If not (containerObject Is Nothing) Then '---- ' Run the Container '---- containerObject.Run If Checkerror("Container.Run") = True Then Exit Sub End If End If '----- ' Save the new project '----- prjObject.Save If Checkerror("Project.Save") = True Then Exit Sub End If '----- ' Close the project '----- prjObject.Close If Checkerror("Project.Close") = True Then Exit Sub End If End Sub Function Checkerror(fnName) Checkerror = False Dim strmsg ' As String Dim errNum ' As Long If Err.Number <> 0 Then strmsg = "Error #" & Hex(Err.Number) & vbCrLf & "In Function " & fnName & vbCrLf & Err.Description 'MsgBox strmsg 'Uncomment this line if you want to be notified via MessageBox of Errors in the script. Checkerror = True End If End Function ... View more

Ok.  I am like @SuryaKiran in the fact that I don't work with .vbs very often.  I have just been able to muddle my way through the files the scheduler in EG generates.   I will see if I can figure out what you are telling me should work.  I don't have access to the tools you mentioned, just EG at the moment. I may have to try and approach this another way all together.   I appreciate all of the help. ... View more

@Reeza    I looked at the post and I am trying to determine where it fits in to what I am doing.  Is it in the code inside the EG process flow?   Let me take a step back, I may have confused the issue.  So, when I created the process flow, I scheduled it based on the schedule creator inside EG.  It automatically generates a .vbs file and adds it to the windows scheduler to run.  Windows scheduler runs the .vbs file directly.  There is no .cmd file involved in that scenario.   In my case, I don't use the task scheduler to kick of a .vbs file for a process, I use a .cmd file to kick it off.   @echo off wscript "\\pncbank.com\corp\NECD\Group\PFS\mortgage\MSR Reporting\Automation\SAS EG Project Automation\FHLMCDaily.vbs" If you run the process flow manually with EG open and you have a prompt that was created in prompt manager, once the process gets to the task calling for the prompt, I enter a date and that is passed to the variable in the code and it completes.  I am wanting that prompt to pop for the user if the .vbs file is run without EG being open, regardless of how the .vbs file is being executed.   Maybe this article can do that but I am having trouble determining how to apply it. ... View more