Results 1 to 10 of 10

Thread: USD 15 VBA Macro To Create A Scheduled Task That Runs Only At Specific Time Interval

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0

    Smile USD 15 VBA Macro To Create A Scheduled Task That Runs Only At Specific Time Interval

    To Create Macro That Would Open up Excel 2007 at specific start and end time(s) or specific time intervals for a specific spreadsheet. There would be multiple spreadsheets, so I just need 1 template that I can modify for each spreadsheet in question.

    - Run the macro within that spreadsheet.
    - Save spreadsheet.
    - Close spreadsheet.

    - Excel can be open at all times if this helps.

    Thanks !

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    So what is the macro required? How will the macro know which spreaasheet to modify? Also, can you share exactly what you are trying to do here?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0
    Ideally, the macro would run in Windows and would initiate the opening of a specific spreadsheet at a certain time. From there it would run a specific macro within the spreadsheet. One completed, it would be saved and closed. Two possible types of spreadsheets would be involved.

    1. Specific time to be opened each day - run macro with spreadheet. Then close.
    2. Always open, but running in intervals with intervals to determined by myself in minutes and seconds.

    Hope that clarifies you question.

  4. #4
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0
    Further... data is to be placed at the next available row.

    Example: it ends the first time in row 728. The next time the macro starts it will dump the data in 729 etc... Once it encounters 30,000 lines, it is to go to the next open blank worksheet etc...


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg. 9gxsUMU53al9k5c8W6QGE8
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h4ISxLD17d
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h4LdsDETim
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg. 9gxDYq2iiZ89h32czjtyR_
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugw_smEwvNffCPr_nrB4AaABAg. 9gvyL53lI1l9gxwd_9-V6z
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugy7vmiHsQ0oUt2QCPZ4AaABAg. 9gvoy4OW6lU9gxwxC5-rL9
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgzuX3uYmqJRtsZIbqF4AaABAg. 9gth61YhXKB9gxxCMdRLA0
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxcPC64RQGmXwO5rft4AaABAg. 9gtQLXaeg0e9gxxNuc5CCM
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwCY8vOs1DFHgYSJwF4AaABAg. 9godrFcyWYw9gxy1odpiRj
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyL5nh_j8w70-YBoUt4AaABAg.9goMcRjwjtc9gxyslvuZKx
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwwWRgmRZNqJKptHR14AaABAg. 9go-DbayTZa9gxzPbefHXf
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwF3wECwc8tVoRmz6B4AaABAg. 9go-5xLQM8P9gxzmB7nkVQ
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyRDmGTHnMdT7dl_qx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 07-11-2023 at 12:22 PM.

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Somewhat. but it doesn't say what exactly needs to be done.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0
    I can upload a sample speadsheet that might give you more insight. I just do not know how to do that within this forum. Any suggestions, or can I email it directly to you ?

  7. #7
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    go to bottom of the editor panel and click the advanced button. now scroll down a bit and you'll see a button for attachment. be weary of file size.

  8. #8
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0

    Attachment

    Here you go....

    This is a small template of one of many spreadsheets that I have.

    In this case, currently I need to go in and activate it manually on a daily basis. Further, I have to stop it manually as well. Ideally, I would want this to start at a certain time and finish at a certain time based on my inputted criteria that I can modify within the module on a daily basis. In this particular case, it downloads the info every minute....
    Attached Files Attached Files

  9. #9
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Code is ready. Please send payment to the paypal Id I will PM you, and I will post the solution here.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  10. #10
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Here's the revised file. You'll notice that I've added a control sheet for you to set the start time and end time of your scheduled activity (macro). When you close the workbook, it will ask you whether you want to make any modifications or not. In case you don't need that, you can take that code out. In addition, I've added an option for you to not initiate the macro next time that the workbook is opened. Just sent a TRUE/FALSE value in Cell B3 of the control sheet.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Import Export Spreadsheet Macro Action Specific Sheet
    By Portucale in forum Access Help
    Replies: 3
    Last Post: 08-06-2013, 07:42 AM
  2. Macro To Browse Select File And Import Specific Data
    By violetpedal in forum Excel Help
    Replies: 4
    Last Post: 07-17-2013, 07:19 AM
  3. Warning Alerts Depending On Time Remaining To Finish Task
    By peter renton in forum Excel Help
    Replies: 9
    Last Post: 06-19-2013, 12:20 PM
  4. Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  5. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM

Posting Permissions

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