+ Reply to Thread
Results 1 to 5 of 5

Automatic updation of workbook without any manual intervention

  1. #1
    Registered User
    Join Date
    10-15-2006
    Posts
    21

    Exclamation Automatic updation of workbook without any manual intervention

    i hope someone can help me with this:

    I have got an excel workbooks having some macros and links with another workbooks.
    I have put the file on the shares and needs to be updated once a while.
    Is it possible that the file automatically runs a macro or updates at a certain point of time without any need of opening it? e.g i just place it somewhere and it keeps on updating (or running a set of macros) itself.

    help wud be highly appreciated!

  2. #2
    Registered User
    Join Date
    10-15-2006
    Posts
    21

    would anybody help me with this please?

    would anybody help me with this please?

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,406
    hi,

    you can use the application.ontime functionality in VBA to call the macros at specified time intervals.

    hth

    dave

  4. #4
    Registered User
    Join Date
    10-15-2006
    Posts
    21

    still there is an issue!!

    i have already used this method but if i close the excel application then the file doesnt update automatically. I want the file to be updating and executing macros even if the application is closed.

    wud anyone still be of help

  5. #5
    Registered User
    Join Date
    07-05-2007
    Location
    Cincinnati, OH
    Posts
    44

    Re:

    So far as I've seen, you need to have a program open to be running macros.....


    If you have another office program that you are often in (Like Outlook or Word for example), you could potentially create a macro in outlook that would be able to execute in excel.

    I encourage you to look at the website below, in their 'OLE automation' section.

    http://www.erlandsendata.no/english/index.php

+ 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