running a macro in Microsoft Project
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 |
running a macro in Microsoft Project
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" "DPingger" wrote: 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 |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com