Opening Word documents with VBA macros

  • Thread starter VGhlUm91bmRQZW4
  • Start date Views 1,906
Status
Not open for further replies.
V

VGhlUm91bmRQZW4

#1
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
 
R

Roady [MVP]

#2
> 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

---
"TheRoundPen" <TheRoundPen> wrote in message

news:A0B0C579-CC8A-4DA6-A687-2312828D9B5D@microsoft.com...
> 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
 
Status
Not open for further replies.

Similar threads

Top