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 / Menus and Toolbars / February 2004

Tip: Looking for answers? Try searching our database.

Menu item to open Excel and PowerPoint

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marie - 25 Feb 2004 16:58 GMT
Using Word 2000. I have a template that opens up when Word
does. (It is in Word's Startup folder.) On the Menu Bar of
this template I have added a menu for reporting forms.
These forms are on a drop down when the reporting forms
menu item is pointed to. Most of the reporting form "open"
through a macro that gets a copy of the appropriate
template because they are Word templates. But some of the
templates are Excel and PowerPoint templates. Presently, I
have these read only and am using a hyperlink to get a
copy of them; however, the template opens up instead of a
copy of it. How can I get a copy of the Excel and
PowerPoint templates as I do the Word ones? Hope this made
sense.

Thanks so much for your help.

Marie
Jean-Guy Marcil - 25 Feb 2004 17:11 GMT
Hi Marie,

I am not sure I understand...

You want to create workbooks from ".xlt" templates and presentations from
".pot" templates, but from Word?
Why? may I ask?
Wouldn't it be easier and less hassle to put all those templates in an
easily accessible folder (You could have a short cut to it on the desktop or
the quick launch bar)and just double click on the template to create the
appropriate file?

From Word you are going to have to use a lot of VBA and make references to
the Excel and PowerPoint libraries... before we get into that, I thought it
would be worth investigating the "why"  and "how"...

Signature

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org


> Using Word 2000. I have a template that opens up when Word
> does. (It is in Word's Startup folder.) On the Menu Bar of
[quoted text clipped - 13 lines]
>
> Marie
Marie - 25 Feb 2004 18:54 GMT
Hi Jean-Guy,

Thanks for your reply. Just to make it cleaner. Our
account managers do 95% of their work in Word. Most of
them are not very computer literate, so to make it easy
for them, I have put everything they need on a dropdown
menu. Whatever report or request they need to make is all
under that one menu item. They don't need to know anything
about folders, etc. To make the most of automation, I
would really like to have them click on a menu item and
pronto they are in any document they might need. Hope that
helps with understanding what I want to do.

Marie
>-----Original Message-----
>Hi Marie,
[quoted text clipped - 21 lines]
>
>"Marie" <anonymous@discussions.microsoft.com> a écrit
dans le message de
>news: 15e901c3fbc0$9ed297c0$a301280a@phx.gbl...
>> Using Word 2000. I have a template that opens up when Word
[quoted text clipped - 16 lines]
>
>.
Jean-Guy Marcil - 25 Feb 2004 20:52 GMT
Hi Marie,

Honestly, to do what you want for your managers for 5% of the time is really
not worth it. Lots of code to write and maintain (new documents, name
changes, folder changes...), toolbar and menus to maintain, also, the
managers can easily screw things up...

Excel and PowerPoint are very easy to configure so that the documents they
need are easily accessible form File > New. Those programs are very easy to
start from the Start button, the Quicklaunch bar or the Office manager.

Trust me, it not worth going through the hassle of writing, implementing and
maintaining code that will be used just to generate files from templates in
other applications, for a 5% chance that it will be needed. The only way I
would see it as a must and worth the effort for a 5% situation like yours is
if I wanted to transfer data from the currently opened document in Word to
another document in Excel or PowerPoint.

As a final thought, let's say that a manager has just closed Word, thinking,
"I'm done!", then she remembers she has a little thing to adjust in an Excel
worksheet... She would have to start Word to get to Excel? Starting 2
applications to actually use only one is not very efficient and it is
slower.

Signature

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org


Hi Jean-Guy,

Thanks for your reply. Just to make it cleaner. Our
account managers do 95% of their work in Word. Most of
them are not very computer literate, so to make it easy
for them, I have put everything they need on a dropdown
menu. Whatever report or request they need to make is all
under that one menu item. They don't need to know anything
about folders, etc. To make the most of automation, I
would really like to have them click on a menu item and
pronto they are in any document they might need. Hope that
helps with understanding what I want to do.

Marie
>-----Original Message-----
>Hi Marie,
>
>I am not sure I understand...
>
>You want to create workbooks from ".xlt" templates and
presentations from
>".pot" templates, but from Word?
>Why? may I ask?
>Wouldn't it be easier and less hassle to put all those
templates in an
>easily accessible folder (You could have a short cut to
it on the desktop or
>the quick launch bar)and just double click on the
template to create the
>appropriate file?
>
>From Word you are going to have to use a lot of VBA and
make references to
>the Excel and PowerPoint libraries... before we get into
that, I thought it
>would be worth investigating the "why"  and "how"...
>
[quoted text clipped - 6 lines]
>
>"Marie" <anonymous@discussions.microsoft.com> a ?crit
dans le message de
>news: 15e901c3fbc0$9ed297c0$a301280a@phx.gbl...
>> Using Word 2000. I have a template that opens up when
Word
>> does. (It is in Word's Startup folder.) On the Menu Bar
of
>> this template I have added a menu for reporting forms.
>> These forms are on a drop down when the reporting forms
>> menu item is pointed to. Most of the reporting
form "open"
>> through a macro that gets a copy of the appropriate
>> template because they are Word templates. But some of
the
>> templates are Excel and PowerPoint templates.
Presently, I
>> have these read only and am using a hyperlink to get a
>> copy of them; however, the template opens up instead of
a
>> copy of it. How can I get a copy of the Excel and
>> PowerPoint templates as I do the Word ones? Hope this
made
>> sense.
>>
[quoted text clipped - 3 lines]
>
>.
 
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.