LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe you could use a windows scheduler that starts your workbook on certain
dates.

Then call your Update_me in the auto_open procedu

sub auto_Open()
call Update_Me
thisworkbook.close savechanges:=true 'maybe???
end sub



Steve wrote:

Hi

Is there a way to run a macro - "Update_Me" - on a fixed date, say the
first of every month?

Thanks in advance

Steve


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert date in macro George Gee New Users to Excel 12 April 17th 06 05:44 AM
How do I insert the date using a macro tara0801 Excel Discussion (Misc queries) 4 February 10th 05 09:09 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
how to alter the date within a macro LWhite Excel Discussion (Misc queries) 2 January 4th 05 01:54 PM
Date and Time Macro m.j.anderson Excel Discussion (Misc queries) 1 December 1st 04 12:35 AM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"