Hi there

I would like start this topic off and look for advice from the people on here.

I have 2 vbs scripts that are scheduled using task scheduler to run. When they run they basically open an excel file and update it with new data from another directory. They basically copy the data from a .CSV file and paste it into the excel workbook. So these 2 excel workbooks that are updated have some graphs and offer some interaction(using macros) for users that use them.

Problems with this
-The tasks that are scheduled use my windows login but this will have to change every 3months so if I had a lot of scheduled tasks, when it came to time of changing the password I would have to change them all individually. This is a problem I would like to overcome!!
-I have to be logged in for these schedules to run. I think I can leave my PC on and locked and schedule them to run but I want to be able to turn off my PC.
-If, for example, I have a scheduled task that runs once a week how do I get around that if I am off sick!! Lets say it was meant to update a weeks worth of data but it didn’t because it did not run then I would have to manually do some intervention for this to get back to normal. This of course would only apply to this scenario. The other scenario, where only the last 60 days is just shown in the graph


Other Questions
How many Scheduled tasks can I run at the same time? For instance at the minute I have 2 that run 15 minutes apart. I have tested running up to 7 .vbs scripts at the same minute via Task Scheduler and this seems to work okay although the scripts are very basic.


So I am writing this to show where I am and where this can go…I am fairly novice at excel, macros and scripting so am looking for general advice. I was thinking of better technologies to apply this to. Although I feel that the method I describe above suits my needs at the minute as these Excel workbooks are relatively easy to put together now (after coming up with the methodology to apply) and easy to make changes to or even redo a whole workbook as I feel that will be required as things are constantly changing in my environment. I am also trying to learn other technologies that would help improve this like javascript or html. So making the above into a web based system would be the aim but how to get there I’m not sure other than keep doing what I’m doing and learning. I also think that a web based system is more time consuming (especially because I am a novice)and may require more resources.

So if anyone has any experience in this area or advice, it would be greatly appreciated. I am just looking for areas I can improve especially some of the issues I have highlighted here and where i would/could take this.

Thanks