Link to home
Start Free TrialLog in
Avatar of jlcannon
jlcannon

asked on

Excel macro auto run when workbook is closed.

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?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

No, you can't run anything in a closed workbook.
Avatar of jlcannon
jlcannon

ASKER

is there a way to use task scheduler with a greater frequesncy than daily?
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial