• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 799
  • Last Modified:

Microsoft Outlook Calendar and Project Gannt View In VB.NET

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?
0
prototye
Asked:
prototye
  • 2
1 Solution
 
Jose ParrotGraphics ExpertCommented:
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.

Jose
0
 
prototyeAuthor Commented:
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.
0
 
Jose ParrotGraphics ExpertCommented:
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 http://www.codeproject.com/Articles/20330/Developing-MS-Project-application-using-Asp-net-VB 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
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=3165&lngWId=10 
and
http://www.plexityhide.nu/ajaxdemo/LetsBuild_ProjectPlanner.aspxwhere 

Hope it is usefulll.

Jose
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now