Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Project Newsgroups
Project Developer
Controlling Project from Access VBA
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Rod Gill, post: 4895575"] Hi, Controlling Project from Access is just the same as from Excel. GetObject only gets an object that already exists. If it doesn't (Project is not running) then an error is returned. This is why you need error checking on to catch this and start Project using a createObject. Remove the comment ' from: 'On Error Resume Next and your code should work provided you have added a reference to Project. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: [URL]http://www.projectvbabook.com[/URL] [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Project Newsgroups
Project Developer
Controlling Project from Access VBA
Top