Obviously you will want to do more where this leaves off, but it should be enough to get you started with using Project from Excel. 'and finally we add a new task to the project Represents the entire Project application. here example with batch or command prompt: start '' explorer.exe (path) so In VBA ms.access you can write with: Dim Path Path'C:Example' shell 'cmd /c start '''' explorer.exe ' & Path ,vbHide. 'we make the new project the active project You can use command prompt to open explorer with path. 'we set the title property (you can do whatever you want here. 'now that we have an application we make it visible Users without Project installed will see this message.

'this checks to see if a valid object has been created. Set pjApp = CreateObject('MSProject.application') Once you have set the reference the code is pretty simple: Here you can see that I'm using Project 2002 as it is version 10. You will probably have to scroll down a bit to find the project library. This should bring up a dialog box showing all of the available libraries. To do this go to 'the 'Tools Menu' in the Visual Basic Editor (hit ALT+F11 to get there from Excel). The first thing that you need to do is to set a reference to the Microsoft Project Object Library.

If that's the slow part, it might be ard to speed it up. So here is a short example which shows opening the Project application from excel, creating a new file and adding a task. vba excel Share Improve this question Follow edited at 4:34 Quill 11.9k 5 39 92 asked at 14:47 Seth39195 33 1 3 Opening up MS Project, and opening up a file in it will be slow. They want to open a Project file from Excel. I have a number of examples of exporting to Excel from MS Project ( exporting task hierarchy and exporting monte carlo simulation data) but many people want to do just the opposite.

Excel vba open ms project file in use