run code automated

[JIM.H.]

Hello,
I have a VB code in excel as a macro. I need to run this
code first day of the month automated. How can I do that?
Thanks,
Jim.

 

[Tom Ogilvy]

Look at the windows scheduler.

Unless you are going to open the file on the first of the month, then using
methods internal to Excel would not be very reliable.

 

[JIM.H.]

can windows scheduler start excel and run macro? Is the a
web site that talks about it, I do not know scheduler
much.
Thnaks,
Jim.

 

[JIM.H.]

can windows scheduler start excel and run macro? Is the a
web site that talks about it, I do not know scheduler
much.
Thnaks,
Jim.

 

[Paul D]

it appears it can. go to www.google.com and type windows scheduler for the
search. you will get several hits for the program
Paul D

 

[Tom Ogilvy]

As far as I know it can.

should be documented in windows help. Perhaps start it up and see if it has
a help menu.