Thanks Julie. I will search for "excel" instead of "word". I am
pretty sure
the code is a one liner - I just don't know it!
Cheers,
Mark
:
Hi Mark,
My comments are inline.
Hi Julie,
Thanks again for your trouble. I certainly havent been clear
enough as I am
trying not to write an essay.
[Julie] You're welcome for the assistance Mark. Don't worry
about
writing "an essay". In almost all circumstances, more
information
is
better than not enough. A more complete description (as
you've
provided below) probably would have saved a fair amount of the
back
and forth we've been doing.
I want my project managers/planners to have access to blank
forms
so when
they get to a certain stage MSP is a complete solution. I
guess
they can
hyperlink the form to the task upon filling the form in.
However,
I am just
looking for an easy link from within MSP to these forms. I
think I
have 3-5
forms. I will place the toolbar button in the relevant table
view.
[Julie] If you don't want to work with hyperlinks -- which it
appears from your comment below you don't -- then you will
have
to
create VBA code to run Microsoft Word and, once in Word,
create
the
document based upon the template. You cann't place toolbar
buttons
on tables, it will have to be a toolbar button which calls the
VBA
module and it will need to be placed on either an existing
toolbar
or on a custom toolbar.
To get insight on writing the VBA code, I'm going to suggest
you
post to the Developer Newsgroup as I am not the person to
guide
you
through the code process. I know you've already posted in the
Developer newsgroup in the past and Jack suggested
hyperlinking.
I
strongly suggest posting the full story -- that you've tried
the
suggestion of hyperlinks and found it didn't suit your purpose
and
that you want to create code to run Word, create a new
document
based upon a template. Before posting, I suggest doing some
reading
experimenting on your own. If you search the Developer
newsgroup,
you will most likely find some snippets of code where people
are
launching Excel from Project. I wouldn't expect someone to
volunteer to write the code. If you want paid assistance,
post
that
in your question.
Jack suggested hyperlinking at summary level which he said
would
be much
easier but with 500 projects I don't like this solution.
I hope we are getting there. Many thanks,
[Julie] You're welcome Mark.
Mark
:
Hi Mark,
Okay, perhaps we should start back at the beginning
You want to be able to run Microsoft Word and open a
specific
Word
file, yes?
Is it the same file for each Project or different multiple
files
per
project?
What relationship is there between the Word document and
the
Project
file?
Is there a relationship between the Word file and specific
tasks?
What about hyperlinking the word document to the specific
task
or
hyperlinking to the Project summary tasks?
To hyperlink a word document to a task, select the task,
click
the
Insert Hyperlink button on the Standard toolbar and browse
to
the
word file. That will add a hyperlink indicator (which I do
not
believe can be changed) to the indicator column. You can
click
on
the hyperlink indicator, launch Word and display the Word
file.
You
can add a note to the task or change the "Text to display"
for
the
hyperlink to give some additional information about the
word
file.
You can only hyperlink one file per task, but you can
hyperlink
to a
folder (directory) if you have more than one file to
reference
per
task.
Have you tried embedding the Word document in the Notes
field
for
the task?
Sorry for so many questions, but I'm trying to understand
better
what you need as well as what you've tried and why that
option
didn't work for you.
Julie
Hi Julie,
Thanks for quick reply again. Unfortunately I am still no
wiser.
1. Macro for Toolbar button I can't see for the moment.
2. I am aware of recording macros but opening a word
document
isn't a
function within MS project!
I bet you'll now point me to the developer side. However
I
asked a
similar
question 2 months ago and Jack persudaded me it was
easier
to
do
this via
hyperlinking a taskbar or something. Now I realise I
don't
want
this option
as part of the programme.
Cheers,
Mark
:
Hi Mark,
Thanks for the clarification. In order for a toolbar
button
to
do
something when you click on it, it will need a macro
behind
it.
Once you create the macro, you can add the macro to a
toolbar
and
then pick a picture for the button face. You can also
create
your
own button face or simply show text. I don't know where
the
list
of
pictures for button images are. However, the following
MS
page
details how to edit button images. Although it does not
specifically mention, Project, I believe it works
exactly
as
detailed.
http://office.microsoft.com/en-us/help/HP051925661033.aspx
The place to start would be to create the macro to open
the
word
file of your choice. If you're not familiar with
writing
macros,
try turning on the macro recorder and stepping through
the
process
to open the word file.
Julie
message
Thanks Julie. Not there yet.
I want to create a toolbar that has shortcuts to one
of
our
standard word
documents. I know how to create a toolbar and add
existing
icons
to it but I
can't see how to add a totally new icon and when the
user
clicks
the icon it
then opens a specific word document.
I am pretty sure I have seen somewhere where you can
create
a
macro and then
assign an icon to run it. In my case I will want it to
open
a
word
document.
I hope I have explained this clearly now.
many thanks,
Mark
:
Hi MarkC,
I'm not sure I follow what it is you want to do.
What
do
you
mean
by "linked to MS Word documents". I don't believe
you
can
change
the default hyperlink icon which appears in the
indicator
column
to
represent anything else.
For some guidance on changing other icons see:
http://www.howtogeek.com/howto/windows/customizing-your-icons-in-windows-xp/
I hope this helps. Let us know how you get along.
Julie
Project MVP
Visit
http://project.mvps.org/ for the FAQs and
additional
information about Microsoft Project
message
I want to be able to add several new commnad icons
that
could
be
linked to MS
Word documents. I've seen a message from Julie
about
downloading
free icons
but I can't seem to add them. How can I do this and
hyperlink
to
