Solved

MSProject98 COM

Posted on 1998-12-09
9
469 Views
Last Modified: 2010-04-04
I have a problem accessing the Tasks in a MSProject98 through the COM interface (msprj98.olb). I can access the property alrite but when I need to get detailed information about the Tasks I get a OLEAUT32.DLL access violation
0
Comment
Question by:jerboa
  • 4
  • 3
  • 2
9 Comments
 
LVL 20

Expert Comment

by:Madshi
ID: 1350045
I don't now the MSProject98 com interface. But if you post some code here, perhaps I'll find a bug in your sources...

Regards, Madshi.
0
 

Author Comment

by:jerboa
ID: 1350046
{Import the 'msprj8.olb' type library to compile}
type
 TProject98 = class  
   private
     FProject98: _MsProject;

constructor TProject98.Create;
begin
  FProject98 := CoApplication_.Create;
end;

function TProject98.GetNumberOfTasks: Integer;
begin
  {This Code crashes}
  Result := FProject98.ActiveProject.Tasks.Count;
end;

function TProject98.GetTasks: integer;
var
  oTasks: Tasks;
begin
  oTasks := FProject98.ActiveProject.Tasks; {This works}
  Result := oTasks.Count; {This crashes too}
end;

0
 

Author Comment

by:jerboa
ID: 1350047
{Import the 'msprj8.olb' type library to compile}
type
 TProject98 = class  
   private
     FProject98: _MsProject;

constructor TProject98.Create;
begin
  FProject98 := CoApplication_.Create;
end;

function TProject98.GetNumberOfTasks: Integer;
begin
  {This Code crashes}
  Result := FProject98.ActiveProject.Tasks.Count;
end;

function TProject98.GetTasks: integer;
var
  oTasks: Tasks;
begin
  oTasks := FProject98.ActiveProject.Tasks; {This works}
  Result := oTasks.Count; {This crashes too}
end;

0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 44

Expert Comment

by:bruintje
ID: 1350048
Hi Jerboa,

Had an evaluation version somewhere on my disk, so did the install to get to the typelib. If the code above is all you have so far then I will explain the errors.

crash 1 is because you have no Activeproject open
crash 2 same reason.

This will get you on your way

procedure TForm1.Button1Click(Sender: TObject);
var
  aProject: OleVariant;
  CurrentTasks: Integer;
begin
  aProject := CreateOleObject('MSProject.Application');
  aProject.Visible := True;
  try
    aProject.FileNew;
    CurrentTasks := aProject.ActiveProject.NumberOfTasks;
    Showmessage(IntToStr(CurrentTasks));
  except
    aProject.Free;//project doesn't support free but the object will be released in case of trouble
  end;
end;


But the beauty (and the trouble) is that all this MS stuff is going through OleVariants. So before you can acces the information you would like to see, you have to create an instance of the application and put it into an Olevariant.
Then you have to go through the object model of Project to acces what you want to have.

If you have any questions about this ask them.
br(UINT)je.
0
 

Author Comment

by:jerboa
ID: 1350049
I had an active project open and the NumOfTasks property worked fine but I need to get the more detailed info that the Tasks interface provides. NumOfTasks is a property of the ActiveProject (works fine in my code too) but I need some code to access the names of each tasks (Name is a property of the Task interface), I get an error whenever I try to access any property of the Tasks interface:

procedure TProject98.GetTaskNames;
var
  oTasks: Tasks;
  FTasks: TStringList;
begin
  FTasks := TStringlist.Create;
  try
    oTasks := FProject98.ActiveProject.Tasks; {This works}
    for iCounter := 1 to FProject98.ActiveProject.NumOfTasks do
      FTasks.Lines.Add := oTasks.Item[iCounter].Name; {This
            code compiles but crashes at runtime}
  finally
     FTasks.Free;
  end;
end;
0
 
LVL 20

Expert Comment

by:Madshi
ID: 1350050
How does the Tasks type look like?
0
 
LVL 44

Accepted Solution

by:
bruintje earned 100 total points
ID: 1350051
Ok. fair enough if you have the olb look good at the structure because I think it's wonderfull stuff to use, made a project form1, button1, listbox1

unit Unit2;
interface

uses
  Windows,
  Messages,
  SysUtils,
  Classes,
  Graphics,
  Controls,
  Forms,
  Dialogs,
  StdCtrls,
  MSPROJECT_TLB,
  ComObj;

type
  TForm1 = class(TForm)
    Button1: TButton;
    ListBox1: TListBox;
    procedure Button1Click(Sender: TObject);
  private
    procedure GetTaskNames(fProject: OleVariant);
  public
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.Button1Click(Sender: TObject);
var
  aProject: OleVariant;
begin
  aProject := CreateActiveOleObject('MSProject.Application');
  aProject.Visible := True;
  try
    aProject.FileNew;
    GetTaskNames(aProject);
  except
    aProject.Free; //project doesn't support free but the object will be released.
  end;
end;

procedure TForm1.GetTaskNames(fProject: OleVariant);
var
  FTasks: TStringList;
  iCounter: Integer;
begin
  FTasks := TStringlist.Create;
  try
    for iCounter := 1 to FProject.ActiveProject.NumberOfTasks do begin
      FTasks.Add(FProject.ActiveProject.Tasks.Item[iCounter].Name); {This code compiles but crashes at runtime}
      next;
    end;
    ListBox1.Items := FTasks;
  finally
    FTasks.Free;
  end;
end;

end.

Hope this helps,
BTW Could make a sample that retrieves more then just the name ask for it and I can see what I can brew.

:O)
Bruintje.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 1350052
and of course things will compile just fine I suspect that delphi doesn't check all these OLE properties to good(correct me if I am wrong.)


0
 

Author Comment

by:jerboa
ID: 1350053
Thanky Bruintje,

Ik heb de OLE Variable van type verandert
    _MSProject -> OLEVariant en nu kan ik wel aan de Task informatie. Dan verlies ik wel een beetje Early binding functionaliteit omdat de compiler niet echt kan type checken. Maar de code werkt en dat is het belangrijkste...
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Copy file in dll not working but working on exe ! 18 92
Delphi TcxGrid group footer summary 3 261
Delphi selector screen 2 78
Delphi Form ownership 4 85
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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