topic Re: Using EG Scheduler to create Excel and not VBS Script in SAS Enterprise Guide

Using EG Scheduler to create Excel and not VBS Script

Shastadaisy0102 — Thu, 30 Nov 2017 21:47:34 GMT

Hi!

I am trying to schedule my project to release in Excel format rather than VBS script. Is that possible? I have it set to export to Excel in the project already, but when it delivers it is always as VBS script. We have SAS EG 4.3

Re: Using EG Scheduler to create Excel and not VBS Script

ChrisBrooks — Fri, 01 Dec 2017 01:04:13 GMT

I think you're confusing two different things here. When you use the Windows scheduler from inside EG then EG will generate a VBS file which contains a VB Script program which runs the Enterprise Guide project in background. If that project exports it's output to Excel then you will get an Excel spreadsheet when it runs.

You can check if this works by double clicking the VBS file - if the Excel file doesn't appear when the program is finished then you have an error in your project.

Re: Using EG Scheduler to create Excel and not VBS Script

Shastadaisy0102 — Fri, 01 Dec 2017 14:33:50 GMT

Thank you so much for your response. I clicked on the VBS Script and got an error. I also noticed the scheduler is not working, it only ran because selected run project after I set up the schedule.
Error: Object Required
Code: 800A01A8
Source: Microsoft VBScript Runtime Error

Re: Using EG Scheduler to create Excel and not VBS Script

fifthand57th — Fri, 01 Dec 2017 19:23:38 GMT

@Shastadaisy0102

See this SAS Note for tips and requirements needed to schedule SAS Enterprise Guide projects successfully: http://support.sas.com/kb/56648. It's worth reviewing this note to ensure you have the permissions/rights needed to schedule.

The script error you received tells me that you may want to ensure that the bitness of EG and the bitness of the cscript.exe file used matches. What is the full version of EG including bitness you are using? (Go to Help -> About SAS Enterprise Guide for this information.) What version of Windows are you using?

If you have a 32-bit install of EG, then you want to ensure that the cscript.exe located in c:\Windows\SysWOW64\ is executing your VBScript file.

If you have a 64-bit install of EG, then you want to ensure that the cscript.exe located in c:\Windows\System32\ is used.

(Yes, the names of these Windows directories are misleading. See https://stackoverflow.com/questions/949959/why-do-64-bit-dlls-go-to-system32-and-32-bit-dlls-to-syswow64-on-64-bit-windows)

Re: Using EG Scheduler to create Excel and not VBS Script

ChrisBrooks — Sat, 02 Dec 2017 00:23:26 GMT

The scheduler may have been disabled by your system administrator - I encountered this at one site and had to ask for it to be enabled on the machine I was using.