Microsoft Outlook Calendar and Project Gannt View In VB.NET

Posted on 2012-08-14
Last Modified: 2012-08-20
I'm looking at designing a GUI in VB.NET for a DB system that holds appointments as tasks, with some items being dependant on others being completed.

The Outlook 2010 calendar looks like it has most of the functionality that I need, and the MS Project Gannt view the rest.
When I look around on the web, there seems to be nothing about using these in VB.NET.  Can these be used? and are there examples anywhere?
Question by:prototye
    LVL 83

    Expert Comment

    LVL 18

    Expert Comment

    Acessing Project internal database is pretty simple with VBA (used as macros). You don't need to install anything more. You can develop it enterely in the Project environment or call them from Outlook, Excel, Word etc.

    Follow a sample code (pure native VBA of Project).
    In the Gantt view, chose some tasks and select them.

    Open VBA editor with: Tools --> Macro --> VBA Editor.
    This should open a dialog window. Then create a VBAproject. Name it as "ReakTask".
    Doubleclick on This Project
    Sub ReadTask()
    Dim tsk As Task
    For Each tsk In ActiveSelection.Tasks
        With tsk
            MsgBox "Task: " & .Name & ". % concluded = " & .PercentComplete "."
        End With
    Next tsk
    End Sub

    Open in new window

    We can create message boxes, which is a powerful feature.
    The VBA dynamic wizard is very good. It provide the available functions and objects to include in your code. Things like Cost, Start, Finish, Resource names, and so on.

    Hope it helps.


    Author Comment

    CodeCruiser :- The users would need to be able to update the chart, so the only one that could possibly work would be the dhlsoft one.  If I went down that route the devexpress XtraScheduler Suite would suite the requirements better.  I'm trying to find out if and how this can be done using ms products (outlook / project )

    Jose :- I need to be able to view, populate (and filter), and save changes made in the gant view or calendar view from a VB.NET winforms application, not from within a standalone project or outlook application.
    LVL 18

    Accepted Solution

    You can develop prototypes in a standalone project, with the support of the wizards included in the Project VBA. This is a very productive approach.
    Then, your actual VB.Net application would use abolutely the same functions and calling formats of such prototypes.
    You can also program directly in VB.Net of course, but it is a little bit hard
    At there is a how-to.

    Your VB.Net application can open a project file, change any attribute of any task (Start, Finish, duration, including customized fields) and write back to the project file. Can also pick those tasks information from Project file and show them in your own VB.Net application forms.

    If you need to view the Gantt chart into your VB.Net form, this is another history. VB.Net forms aren't able to do it. You'll need 3rd part components, like the ones at

    Hope it is usefulll.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now