AutoSave a doc based on a form field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Lozzi - 16 May 2006 17:52 GMT

Howdy,

I have a word doc which users enter in field information. The form is locked
and data entry is great. When the users leave a field, log no, I'd like to
autosave the document using a macro. So after they leave field LogNo, save
the document as "report_12334.doc" to the default directory. Well, this is
pulling from SharePoint WSS, so it should save back to the WSS list. How do
I write a macro like this?

Thanks!!

Signature

D a v i d L o z z i
Data & Web Technology Specialist
Delphi Technology Solutions, Inc.
Wilmington, MA
dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com

Reply to this Message

Cindy M -WordMVP- - 17 May 2006 10:13 GMT

Hi David,

> I have a word doc which users enter in field information. The form is locked
> and data entry is great. When the users leave a field, log no, I'd like to
> autosave the document using a macro. So after they leave field LogNo, save
> the document as "report_12334.doc" to the default directory. Well, this is
> pulling from SharePoint WSS, so it should save back to the WSS list. How do
> I write a macro like this?

Well, getting the macro to execute is simple enough, just assign it from the
"On Exit" in the field's options.

How to save to WSS: try recording using File/Save As in a macro to a WSS
folder. That should give you an idea what the file path needs to look like.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message