Sephir
08-16-2007, 11:53 PM
Hello!
I want to save my word doc every X minutes (input from user) with file name increased with number (example: test.doc, test1.doc). I come with this:
ActiveDocument.SaveAs FileName & counter & ".doc"
DoEvents
Application.OnTime When:=Now + TimeValue(sTime), Name:="newSaveDoc"
counter = counter + 1
My questions are:
1. how to check if file is opened, and if it is not, then display message about opening file
2. how to stop this function on file close.
3. how to stop this function manually (i want to let user to stop it manually).
4. any possibility to let user chose directory? i try to use dialog save as, but it gives me .doc and then i get test.doc1.doc
thanx
I want to save my word doc every X minutes (input from user) with file name increased with number (example: test.doc, test1.doc). I come with this:
ActiveDocument.SaveAs FileName & counter & ".doc"
DoEvents
Application.OnTime When:=Now + TimeValue(sTime), Name:="newSaveDoc"
counter = counter + 1
My questions are:
1. how to check if file is opened, and if it is not, then display message about opening file
2. how to stop this function on file close.
3. how to stop this function manually (i want to let user to stop it manually).
4. any possibility to let user chose directory? i try to use dialog save as, but it gives me .doc and then i get test.doc1.doc
thanx