Controlling Excel,Word from MSProject

shekharjoglekar

New Member
Joined
Oct 13, 2005
Messages
5
Friends,

I have written some macros in VBA of MSProject. I need to create some Excel and Word files from MSProject itself. I know that I need to setup References to object libraries of VBA Extensibility, Excel and Eord libraries and thus these macros work on my machine. My problem is when I ditribute my macros to users who do not understand VBA and are remote. How can I set these references automatically through the install process from MSProject VBA macro?

I install the MSProject macros in the Global.MPT. And these macros do not work until these refernces are setup in the destination machine. Since the users are remote, I need a programmatic or automatic way to do this. is it possible?

Peculiarly, this did not seem to be needed when the user had to open a template MPP file which contained the macros. He could run the macros without setting the tools/references. But when running from Global.MPT, this seems to have become a necessity. Anyone can help?

Shekhar
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,094
Members
412,766
Latest member
BigRusty82
Top