Hi All,
I have used VBA in Excel several times, so I'm trying to get a handle on it
in Word.
I have a template which I would like to save to a specific location after
people have filled it in. I have (with the help of this group) a macro which
does this, but I'd like to assign a command buton to it.
I have tried to draw in a command button and then copy and paste the macro
to it, but this doesn't seem to work and it also has a habit of making the
template open with the toolbox toolbar in the middle of the page and the
"edit" button pressed. This is very annoying and I can't seem to get rid of
it, even if I unclick the "edit" button and close the toolbox and then save
it again as a .dot template.
This is the macro (if it's important) which doesn't seem to work. It
basically doesn't run if I link it to the command button, but it does if I
keep it as a macro and then use the Macro/Run command.
Private Sub CommandButton1_Click()
'recorded by fiona to try to save this in the correct folder
FilePathName = "S:\Administration\Joanne\Travel\"
strDate = Format(Date, "ddmmyy")
ActiveDocument.SaveAs FileName:=FilePathName & Application.UserName &
strDate, FileFormat:=wdFormatDocument
End Sub
All the lines of working code are one line, this forum seems to have wrapped
it so ignore that. As I said, when it is actually a macro it works, when I
try to use it in a command button it doesn't. I've checked that the command
button's name is correct in the properties box.
Any help would be gratefully received.
Thanks,
Fiona
Jean-Guy Marcil - 11 Feb 2005 15:02 GMT
fiona was telling us:
fiona nous racontait que :
> Hi All,
>
[quoted text clipped - 11 lines]
> can't seem to get rid of it, even if I unclick the "edit" button and
> close the toolbox and then save it again as a .dot template.
Since you are working from a template and that user will create documents
from the template, by far the easiest would be to create a toolbar with a
single button, or add a button to an existing toolbar.
Open the template > Tools > Customize > Commands tab > Macros on the left >
Find your macro in the list on the right > Drag and drop it on the toolbar
to create the button > Right click the button to access its properties
(Change its name, display text/picture, etc.).
Another advantage to that method is that the button will not print, it will
not take real-estate on the document itself and will always be visible to
the users, regardless of the page they are working on.

Signature
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org
fiona - 15 Feb 2005 04:51 GMT
Thanks Jean-Guy. A simple solution I often forget! It worked perfectly and
everyone who needs the template has access to the macro.
> fiona was telling us:
> fiona nous racontait que :
[quoted text clipped - 26 lines]
> not take real-estate on the document itself and will always be visible to
> the users, regardless of the page they are working on.