+ Reply to Thread
Results 1 to 4 of 4

Automate an Excel process

  1. #1
    msnate
    Guest

    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. #2
    Dave Patrick
    Guest

    Re: 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. #3
    msnate
    Guest

    Re: 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. #4
    Dave Patrick
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1