Automate an Excel process
 

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

Automate an Excel process
 

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
|

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
|

Automate an Excel process
 

You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"msnate" wrote:
| Sounds great and thanks.