running a macro in Microsoft Project

[DPingger]

Hello,

In my worksheet macro, I'm trying to open a Microsoft Project file, run a
macro in it (which creates an excel file which I will use), close Project,
and return to my worksheet and finish running the macro.

Help.

TIA

DPingger

 

[DPingger]

Hello,

This is what I've added into my excel macro. It's giving me a compile error.

Please help. What's missing?
TIA

DPingger


ChDir _
"C:\Documents and Settings\gordopi\My Documents\J-UCAS
Sched\IMS-UCAS-D"

FileOpen Name:="C:\Documents and Settings\gordopi\My Documents\J-UCAS
Sched\IMS-UCAS-D\X-47B UCAS Draft IMS 09-Oct 07.mpp",
FormatID:="MSProject.MPP"