Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2005

Tip: Looking for answers? Try searching our database.

Command Button Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fiona - 11 Feb 2005 04:15 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.