Macro not saved in document when sent to others

[ReportSmithing]

I've created an application (vb based) allowing the user to push a button which then opens a word document and pokes data elements into specified bookmarks in the word doc - this doc is stored on a shared drive at my work.

I knew that multiple users would be accessing this doc, so my application (after all the data elements are added) will then use DDE Execute:
DdeExecute("WinWord","System","[Toolsmacro.name=""SaveIt"",.Run]")
This command then runs a macro I have within the word document that changes the users directory and saves this doc to the users C:\TEMP directory.

MY PROBLEM: This works just fine on my local computer. If I run this app from anywhere else (not on my machine), Word is unable to find the macro! How can I save a document, send it to someone AND have the macro attached with it?
I've read something about templates, but templates (from what I've tried) can not retain my poked elements - it can't be changed or altered. Does this have something to do with Global scope vs Local scope? How would I do this?

 

[PHV]

What is the macro security level of the other computers ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886