Saving backups

S

Samuel Marin

Hi. I am new to VBA for Word but I already know a couple of things in VBA for
Excel. I'd like to program an autosave sub that would save a .doc file
automatically to a specified location (on my home network) each time the
'save' button is pressed. I have seen in the VBA help that it can be done
through a Class module and an event handler. I am afraid this is far from
what I can take.
Can anyone think of a simpler solution? Or would anyone take some of their
time to explain such basic programming to one in need?
Thanks a lot.

Sam.
 
C

Charles Kenyon

It has already been written by Graham Mayor.
http://gmayor.com/automatically_backup.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
S

Samuel Marin

Hi.
Neat information, this. My thanks. However this does not solve my problem
completely as the macro needs to be activated manually. I really need that
event handler that will start the autosave Sub when I press the standard
'save' icon.
Can anyone think of a simple enough way to perform this?

Sam.
 
C

Charles Kenyon

He shows how to put it on a button. You can put in on your Save button if
you want.

If you want, you can even intercept the variations on the Save command so
that you will have no choice in the matter.
http://word.mvps.org/FAQs/MacrosVBA/InterceptSavePrint.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
C

Charles Kenyon

The article tells you how to put it on your toolbar so you can click the
button for this kind of save instead if you want.

If you really don't want to give yourself any choice, see
http://word.mvps.org/FAQs/MacrosVBA/InterceptSavePrint.htm.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top