D
Dustin Ventin
I'm using VBA in Access to open and work with Microsoft Project, making
extensive use of the VBA functions to work with Project using only code. One
of the major things we would like to do, though, is fairly simple... we can
create a new project with the click of a button, but it keeps coming up and
asking the user to 'overwrite, append, or cancel'. Obviously, since this is
supposed to be automatic, and we certainly don't want to overwrite, we always
want to append.
Now, I've written a macro before that uses SendKeys to select the 'Append'
and then 'Enter'. The trouble is, I'm having trouble figuring out how to
tell MSP to activate SendKeys from inside Access VBA. It doesn't appear in
the normal list of Project functions... any ideas?
Thank you,
Dustin
extensive use of the VBA functions to work with Project using only code. One
of the major things we would like to do, though, is fairly simple... we can
create a new project with the click of a button, but it keeps coming up and
asking the user to 'overwrite, append, or cancel'. Obviously, since this is
supposed to be automatic, and we certainly don't want to overwrite, we always
want to append.
Now, I've written a macro before that uses SendKeys to select the 'Append'
and then 'Enter'. The trouble is, I'm having trouble figuring out how to
tell MSP to activate SendKeys from inside Access VBA. It doesn't appear in
the normal list of Project functions... any ideas?
Thank you,
Dustin