Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing MS Project File from Excel VBA
I posted this in another forum, but because there seems to be no other
information on the topic i felt it would be beneficial to ask here as well. (link to original post: http://www.excelforum.com/showthread.php?t=626117) What i'm attempting to do is edit a Microsoft Project file from an Excel VB Macro. We have a program that populates most of the necessary fields of Project file automatically, but other critical fields (durations) will need to be entered manually. To expedite the process, i'm attempting to create an Excel template for the responsible parties to update and would like the macro to then update the Project file. I realize there are easier methods other than macros to do this, but as there are 30,000+ lines, many of which are repeated, a macro would be the most efficient. The only code i have been able to find that even links the two different MS programs is this: Set ProjApp = CreateObject("MSProject.Application") With ProjApp .Visible = True ' xxxxxx .Quit End With Set ProjApp = Nothing While it does somewhat link the two programs, i'm experiencing problems right off the bat and am fairly certain that is not the best way of doing what i'm needing. Any advice, examples, or references would be much appreciated. Thanks in advance, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
downloading excel file for open causes "file is locked for editing | Excel Programming | |||
Editing a Read Only Excel File via VBE | Excel Programming | |||
My excel file is locked for editing. How do I get it opened. | Excel Worksheet Functions | |||
Trying to Open Excel File, But its says file is locked for editing | Excel Discussion (Misc queries) | |||
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project | Excel Programming |