Desktop productivity for business analysts and programmers

vbs and EG

Reply
Contributor
Posts: 73

vbs and EG

Hi
a little birdy suggested me to post here a question about the launch of a VBS in EG.

The question is simple perhaps naive but could I execute this data inside EG
1. if the session invoked is on the same machine than EG (personal computer with an EBI platform)
2. on a remote server

options noxsync noxwait xmin ;
data _null_;
x 'd:\stef.vbs';
run;

On my personal computer with EBI, this step leaves the session running and I have to kill the process.

Does EG not support OLE launch as DDE launch and I have no possibility to run that ?

stef.vbs :

option explicit

dim word 'the Word application
dim doc 'the Word document
dim selection 'text selection

set word = createobject("word.application")
word.visible = False
word.DisplayAlerts = 0
set doc = word.documents.add
set selection = word.selection
selection.typetext "An Automated Word Report"
selection.typeparagraph

doc.saveas("d:\zztestdoc.doc")

word.Quit

set word = nothing

Any idea ?

Edit : I can successfully execute x command like that
data _null_;
x 'echo "funstuff"> d:\temp\myfunstuff.txt';
run;

data _null_;
x 'mkdir d:\temp\hello';
run; Message was edited by: Stephane
Contributor
Posts: 73

Re: vbs and EG

From me to me : you need a administrator user on the machine and then the vbs will be executed.
Community Manager
Posts: 2,697

Re: vbs and EG

Ask a Question
Discussion stats
  • 2 replies
  • 115 views
  • 0 likes
  • 2 in conversation