Opening Word documents with VBA macros

[TheRoundPen]

Hello,

We are using Office 2003. I have created a company-wide employee evaluation
form (in Microsoft Word) that creates custom toolbars and runs VBA code and
macros. After the evaulation is originally created, it is forwarded to a
representative in HR for review. At this point the HR Reviewer should see
the same custom built toolbars. This is not happening. When the document is
opened directly from the email, none of the code is functional (the user is
not even prompted to enable macros). However, if the file is saved first and
then opened the full functionality is there. Our reviewer and General
Manager (who the files are forwarded to for a final review) do not want to
have to save every evaluation to their hard drive in order to review the
document and make any comments or edits to it.

Is there a solution from within Outlook? Is there a way to open a Word
attachment in something other than "Read-only?" If, so I would be eternally
grateful to know it!

Thank you,
Carla McDonald

 

[Roady [MVP]]

Is there a solution from within Outlook?
No, as it is a Word security feature. You can assigns folders as trusted
locations which would allow you to run VBA. Ask in a Word newsgroup for more
details.

Is there a way to open a Word attachment in something other than
"Read-only?"

Yes, don't open the attachment from the Reading Pane but double click the
message first to open it in its own window and then open the attachment.

As long as you are in the VBA world; you can also create them a button in
Outlook to run a macro to save the attachment into a certain area and then
to open the attachment from that location.

You can modify the code from this example quite easily to achieve that;
http://www.howto-outlook.com/howto/saveembeddedpictures.htm



-----