I am using Office97. I am trying to "extract" the year from:
MyDate = Format(Date, "dd, ddd mmm yyyy")
Both;
Format(MyDate, "yyyy")

I have a document that is filled out predominantly on the document with two
userforms to accept information I would like to change inputting information
to a userform with multipage. this is where my problem starts my form has
several section so I would like to create a userform ...

Hi gang.  The code below is intended to remove all "optional hyphens" in
a document that aren't being "used" (that is, aren't at a line break
doing their job).  It compares the vertical position of each found
hyphen with the vertical position of the character following it and

I'd like to write a macro that saves my current file with its filename
followed by the date and time. For example, if the file is called Test.doc
and the date and time is 25 Feb 2004, 10:33pm, the backup file would be
called Test_040225_2233.doc. The current file name after running ...

I have a word document that I build with VBA code that
currently copies and paste Powerpoint slides into it via
automation.  I need to change this to only allow PDF
slides so the user cannot edit the document.  I cannot

Hello, I am trying to link a word template to open in a
new browse, however I need it to open a new document base
on the template so that the Macro will run which has
popups to fill out the documant. The only information I

I'm new to Word VBA, although I know a little of Excel VBA.  I'm
working in Word 2000 and I want to create a macro that will search a
directory on my network (h:\fms requirements\testing\) and all of its
sub directories (there a re about 20 sub directories) and print every

I am having a little bit of a problem with a document and version
controlling it at work and would like to create a macro or couple of
macros to help.
Basically i have no experience of VBA, but have fiddled with it in

I have copied the contents of a Word template to a new template using Edit,
Select All, then Paste.  The original template uses a macro to open the
Address Book and then the user selects a name and the fullname, fax number
and company name are inserted into fields on the new ...

I need to display lab values for possible edits/deletes on a user form. I
use DAO to find the correct patient values. I need suggestions on the most
efficient way to take several rows of numerical lab values and display them
for view/edit on a user form. So far I have collected the ...

Using a template with locked formfields. Some issues:
1. Autocorrect deletes a wrong spelling but does not replace the word with
the correct spelling.
2. Spell check doesn't seem to function.

I wanted to ask you if there was a better way to achive this.
My organisation has reports/memos the author completes with  a large margin
on the left side.  The supervisor has margin notes indicating where the
report is to go etc.  Usual practice is to place the report through the

Please look at the code below and help me figure out why
this gives me an error at the end when it is running?
It says End With/Sub
'Get Outlook if it's running

I have a listbox and want the default value of the listbox to be the same
that was last used.
ie: if the user picked option "5" then next time that template is run I want
the default to be option "5".

I am showing the Insert Table of Contents dialog box using
VBA.  "Dialogs(wdDialogsInsertTableofContents).Show"
When i do this, the Show Levels box has a 9 in it.  How
can I change this to 3.