Results 1 to 4 of 4

Thread: run a macro in excel on a schedule

  1. May 26th, 2000, 03:30 AM #1
    Bebe
    Bebe is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    anyone know how to run a macro at a certain time ever week automatically?

    does the ontime method work?
    Reply With Quote Reply With Quote
  2. May 26th, 2000, 03:56 AM #2
    Nias
    Nias is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Omaha, Ne
    Posts
    65

    Cool Macro

    You need a scheduler to launch it at a given time. I know one came with Win 98 and I use it daily to do routine stuff. Which OS are you using?
    Reply With Quote Reply With Quote
  3. May 26th, 2000, 05:02 AM #3
    Bebe
    Bebe is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2000
    Location
    bebenia, PA, USA
    Posts
    241
    windows NT -- so does it run the macro or open the template or how can it work?
    Reply With Quote Reply With Quote
  4. May 26th, 2000, 12:33 PM #4
    Nias
    Nias is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Omaha, Ne
    Posts
    65

    Thumbs up Excel Macros

    For the command line you would simply have suchandsuch.xls and then NT has an association to Excel for xls and it will open Excel and load the spreadsheet. In the spreadsheet you will have under workbook a macro built in that will run everytime the spreadsheet is loaded (sort of like autoexec) but I think it is called on_load (not for sure on that part but I can research it Tuesday). The last few commands in the macro will be a application.saveas and application.quit.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width