My requirement is like this. I am having an Excel Macro which will pull data from Quality Centre and update the sheets. The main purpose of this Excel is to tack the daily status of the project. Instead of running the macro daily, I need this to be automated. Say, the Excel Macro should pull the details from QC on every week days morning 0800 AM. Provided the Excel should not be opened.
Can this be done through VBS? If so can anyone help me out of this?