Automate an Excel process

[msnate]

I have a process that via an Excel (import data) funtion using AcuODBC
driver will populate a spreadsheet with the "cobol data" from a Unix
system. I need to Automate this so it runs once a month automatically.
Can someone offer suggestions/sample of a step to accomplish this.
Thanks

 

[raypayette]

I would use the Windows capabilities. Look in your programs,
Accessories, System Tools, Scheduled Tasks, Add Scheduled Task... that
will pop up a wizard.

 

[Guest]

I this this post will get you moving in the right direction:
http://krgreenlee.blogspot.com/2006/04/excel-running-excel-on-windows-task.html

Good luck,

Kim Greenlee

 

[msnate]

This is a great write-up and is very much appreciated. Thanks for all
the help.