SAS Add-in Scheduler using an Input Schedule File

eduong58 — Tue, 27 Jul 2021 20:23:09 GMT

Hi. I'm looking a way to create a scheduler in SAS Add-in using my own schedule file to refresh the Excel file without opening it. The schedule file should look like following table: (Note: always run at 5am)

CURRENT MONTH	CURRENT YEAR	DATERUN
January	2021	1/1/2021
February	2021	2/1/2021
March	2021	3/2/2021
April	2021	4/3/2021
May	2021	5/3/2021
June	2021	6/6/2021

I think I need to update VBS Script file in order to import and read the schedule file but I don't know how. Attached is the VBS Script file. The schedule create it when I use the schedule that SAS Add-in has.

Thank you in advance!

Re: SAS Add-in Scheduler using an Input Schedule File

ChrisNZ — Tue, 27 Jul 2021 23:24:28 GMT

Comments:

Are you asking for vbs tips?

Please post the contents of your file (using the </> icon) rather than asking us to download it.

I would strongly recommend using a CSV file for your data rather than an excel file, it would be much easier to process in a vbs script.

topic SAS Add-in Scheduler using an Input Schedule File in SAS Programming

SAS Add-in Scheduler using an Input Schedule File

Re: SAS Add-in Scheduler using an Input Schedule File