Excel macro auto run when workbook is closed.

Posted on 2013-09-24
Medium Priority
Last Modified: 2013-09-24
I have an excel workbook that i have a macro that copies all the data from a .csv file to it. I need this macro to run every 10 minutes even if the excel workbook is closed. is there a way to do this?
Question by:jlcannon
  • 2
LVL 52

Expert Comment

by:Martin Liss
ID: 39519074
No, you can't run anything in a closed workbook.

Author Comment

ID: 39519101
is there a way to use task scheduler with a greater frequesncy than daily?
LVL 52

Accepted Solution

Martin Liss earned 2000 total points
ID: 39519145
Apparently so although I've never used the scheduler. Take a look at this article. Under Advanced it says

1.      Click the Schedule tab, and then click Advanced.
2.      Click to select the Repeat task check box, and then specify the number of minutes or hours in which you want the task to be repeated.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question