Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Office Project Manager
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Office Project Manager
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...b;EN-US;167223 Microsoft Office 2000 Automation Help File Available (Q260410) http://support.microsoft.com/default...b;EN-US;260410 Microsoft Office XP Automation Help File Available (Q302460) http://support.microsoft.com/default...b;EN-US;302460 http://msdn.microsoft.com/library/en...ortal_7l45.asp Automation Programmer's Reference http://support.microsoft.com/default...b;EN-US;253235 FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides Sample Code -- Regards, Tom Ogilvy "Marijan Glavac" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office Project vs. Office Web Component | Excel Worksheet Functions | |||
Merging excel office data into a publisher office project(Australi | New Users to Excel | |||
*****Upgrading Calendar for Office Manager***** | Excel Worksheet Functions | |||
MS Office 2000 - Small Business Financial Manager | New Users to Excel | |||
Creating separate reports for each Project Manager | Excel Discussion (Misc queries) |