There used to be a problem note about this, but it has disappeared from the SAS website (DBMS=XLS is a very old format). As far as I can make out, you may be able to get the correct name if you use a longer name (6 characters, I think), it may be that you can get around the problem that way. A better way may be to switch to a newer version of the Excel interface, e.g. using DBMS=XLSX, or perhaps DBMS=EXCELCS. ... View more

To get the SAS log, you will need to use the automation object model to navigate the project and retrieve the log objects from each task to find the error. There are some examples here in VBScript that you can look at for ideas. ... View more

@isek wrote: Hello,   I have a project business guide which I want to run only one branch. Here is my code, but it does not work. Can somebody help me please about     # Launch the application using the registered prog ID $eguideApp = New-Object -comObject SASEGObjectModel.Application.4.3 $chemin = "C:\Users\Desktop\test.egp" $project = $eguideApp.Open($chemin,"") # Show all of the process flows in the project $pfCollection = $project.ContainerCollection $pf=$pfCollection.item("Connexion") Write-Host " 1 - EXECUTION DU FLUX DE PROCESSUS " $pf.Name # To RUN a process flow, simply use $pf.Run() $pf.Run() $pf=$pfCollection.item("pgm trim1") Write-Host " 2 - EXECUTION DU FLUX DE PROCESSUS " $pf.Name # To RUN a process flow, simply use $pf.Run() $pf.Run() $project.Close() $eguideApp.Quit() Did you resolve it ? Regards Veeao ... View more

Protected View is a feature of microsoft office. I don't think it can be influenced through manipulation with SEG. Maybe if you export to .xlsx the behaviour is different? ... View more

Those look like the correct steps.  You can turn on Application Logging (Tools->Options) and EG should generate a POWERSHELL*.log file in your profile folder.  Some messages in there might indicate what's missing.  If you can't solve it, I suggest opening a SAS Tech Support case. ... View more