Thread: Save
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JohnUK JohnUK is offline
external usenet poster
 
Posts: 173
Default Save

Many thanks Tom.

"Tom Ogilvy" wrote:

Application.OnTime

See Chip Pearson's page on this

http://www.cpearson.com/excel/ontime.htm

It is not preemptive, so if Excel is busy it will not run - however, it has
an option to try again.

--
Regards,
Tom Ogilvy


"JohnUK" wrote:

Hi Guys,
Is there a way that a workbook can be saved say, every half hour through VBA.
Also if it is possible, if another macro was to be running at the same time
would it interfere in some way?
Many thanks for help
John