Save
 

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

Save
 

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

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