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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing MS Project File from Excel VBA
Why we cannot use simple cut and paste please?
-- Regards PY & Associates wrote in message ... 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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing MS Project File from Excel VBA
Cut and paste would be easiest, but incredibly time consuming. As i
said, (ideally) the responsible parties will update a template containing tasks relevant to them. The macro will then locate those tasks dispersed throughout the 30,000+ lines and update accordingly. Because this could/probably will be done numerous times throughout the duration of the project, it would be much more efficient to have a macro take care of the searching and locating, then copying/pasting automatically. I've been pointed to references by others and will post them here after i've had a chance to do some research, but if anybody out there has any ideas please let me know. Thanks again. On Dec 8, 8:45 am, "KC Cheung" wrote: Why we cannot use simple cut and paste please? -- Regards PY & wrote in message ... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing MS Project File from Excel VBA
We are assuming you have Activities, Duration etc in Excel spreadsheet.
We always do this. Copy the whole column of 30,000+ durations; Switch to Project; Click top cell in duration column; Paste; -- Regards PY & Associates "the dude" wrote in message ... Cut and paste would be easiest, but incredibly time consuming. As i said, (ideally) the responsible parties will update a template containing tasks relevant to them. The macro will then locate those tasks dispersed throughout the 30,000+ lines and update accordingly. Because this could/probably will be done numerous times throughout the duration of the project, it would be much more efficient to have a macro take care of the searching and locating, then copying/pasting automatically. I've been pointed to references by others and will post them here after i've had a chance to do some research, but if anybody out there has any ideas please let me know. Thanks again. On Dec 8, 8:45 am, "KC Cheung" wrote: Why we cannot use simple cut and paste please? -- Regards PY & wrote in message ... |
Reply |
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 |