I am a beginner programmer and have never created a .bat file. Although I have "some" prior knowledge of VB.
I am in need of creating a bat file (or something comparable) that I can put into Scheduler to run every morning.
The idea is to open Excel (Excel is set up to open the file automatically), pause for 30 seconds (an automatic update happens during this time), save the file (overwrite), and then close Excel.
I have not been successful finding switches for Excel (start it, save and close). Any switches, examples or ideas you can provide would be extremely helpful. Thanks, Alexa