Strange problem with VBA and macros

[Veena]

Hi.
I am using Word 2000 with VB on Windows 2000.
We have created a macro (in WORD) which is called from VB through the
"Run" method.
The macro works fine.
The problem is that when i run the VB code, from visual basic IDE,
everything works fine as expected and the macro executes properly.
But, when we make the executables and run it, the application throws
the error "Unable to run the specified macro". Further, the code which
calls the macro is compiled as an ActiveX DLL and the code is invoked
on the start method of a NT service.
Any advice would be greatly appreciated.
-Regards,
Veena.

 

[Jezebel]

Why not put the macro code into the VB application? It's better practice to
have all your code in the one place, and it avoids problems such as you
describe.