Posted to microsoft.public.excel.programming
|
|
Automate an Excel process
Sounds great and thanks.
Dave Patrick wrote:
Schedule it with Task Scheduler (using a VBScript)
Option Explicit
Dim filePath, oExcel
filePath = "c:\Test.xls"
Set oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open(filepath)
oExcel.Run "macro1"
oExcel.ActiveWorkbook.Save
oExcel.ActiveWorkbook.Close
oExcel.Quit
Set oExcel = Nothing
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"msnate" wrote:
|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
|
|