Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | |
#3
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 | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
way to automate this process | Excel Discussion (Misc queries) | |||
Macro to automate process | Excel Discussion (Misc queries) | |||
need to automate process | Excel Discussion (Misc queries) | |||
Automate deletion process | Excel Worksheet Functions | |||
How to automate process of replacing values? | Excel Discussion (Misc queries) |