CMS auto scripting to run weekly reports

[Merrie]

thread690-856724

Hi

I've set up a script to run a weekly vdn report and another to import it into a specific file using windows scheduler.

I wondered if it was possible to amend the script so that it would change the date of the report automatically and also change the name of the file saved.

Does anyone have any ideas on how to get this to work. I'm a complete novice with VB, any help will be welcome!

 

[lopes1211]

If it's a weekly report, the easiest would be to just change the date in the original report to "-7" instead of a fixed date like "1/15/10". That way it will always run the report for the previous week.

-CL