Auto Openworkbook every 10 minutes

[Balamurali]

Hi,

I have excel macro file. i want to open that excel file every 10 minutes and run macro file then close the excel file.

Need your help
Thanks

 

[kpark91]

Try looking into task scheduler in your computer (make it open your file every 10 mins and then your code can take it from there)

 

[Balamurali]

the system tools task schdule is not available to set in minutes.

thks for your reply

 

[kpark91]

It seems to be available every 5 mins, 10 mins, 15 mins, 30 mins, 1hr, ... in Windows Vista FYI


What Windows do you use just for my information?

 

[Balamurali]

hi
thks for your reply

bcoz am using Win XP

is it possible to set time in every minutes

thks

 

[Ruddles]

See http://support.microsoft.com/kb/308569 (Advanced Options).