MS Office Project Manager

[Marijan Glavac]

Hi,

I need a lot of date from *.xls sheet put into specific columns and rows in
MS Office Project Manager file.
for example :
in *.xls file :
A1="Transport";B1="2d"
A2="Welding";B2="2h"
and I want it into MS Project Manager in column task and duration :
Task Duration
Transport 2d
Welding 2h

Macro will solve my problem.
I don't know where to start.It is possible to do that ?

Please help.
Thanks in advance.

Marijan

 

[Tom Ogilvy]

You can manipulate Project from Excel or Excel from Project using
Automation:

Microsoft Office 97 Automation Help File Available (Q167223)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;167223

Microsoft Office 2000 Automation Help File Available (Q260410)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;260410

Microsoft Office XP Automation Help File Available (Q302460)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;302460

http://msdn.microsoft.com/library/en-us/automat/htm/autoportal_7l45.asp
Automation Programmer's Reference


http://support.microsoft.com/default.aspx?scid=kb;EN-US;253235
FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides
Sample Code