PDA

View Full Version : Solved: Using timer to close workbook



Ken5000
02-26-2011, 10:24 AM
:banghead:

I am looking for VBA code for XP professional and Excel 2003.

Timer code that after let's say 5 min will close and save workbook.

Thanks in advance

mdmackillop
02-26-2011, 10:37 AM
Welcome to VBAX
Try this new entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=308) to the KB by Paleo.

Ken5000
02-26-2011, 10:54 AM
Thanks I'll check it out.

Ken5000
02-28-2011, 06:10 AM
:bow:
Sorry that it took me a long period of time to get back.

Tried it, tweaked it, seems to be working perfect.

Thanks 1 million.

I knew an answer was out there, I just couldn't find it.

:rotlaugh: