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,
--
Regards
PY & Associates
<andrew.li...@gmail.com> wrote in message
news:530922d5-6953-4fa4...@b1g2000pra.googlegroups.com...
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" <pynaso...@yahoo.com.sg> wrote:
> Why we cannot use simple cut and paste please?
>
> --
> Regards
> PY & Associates<andrew.littlefi...@gmail.com> wrote in message
>
> news:530922d5-6953-4fa4...@b1g2000pra.googlegroups.com...
>
--
Regards
PY & Associates
"the dude" <andrew.li...@gmail.com> wrote in message
news:1593bd37-a5fa-4764...@e25g2000prg.googlegroups.com...