SAS Add-in Scheduler using an Input Schedule File

[eduong58]

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!

[ChrisNZ]

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.