Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro to extract information from MS project files
hi all ,
i need help to create a macro on excel which extract information from Ms project files , someone can give me some information or code of macro .... thanks in advance zouzou |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro to extract information from MS project files
Hi
i don't know specifically of any excel macros that grab info out of project, but you might like to check out Jack Dalgren's project macro site http://masamiki.com/project/macros.htm he's got a few that will export project information to excle also don't forget the analyse timescaled data in excel toolbar in project, that's pretty handy for getting project info into excel. Cheers JulieD "zouzou" wrote in message om... hi all , i need help to create a macro on excel which extract information from Ms project files , someone can give me some information or code of macro .... thanks in advance zouzou |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro to extract information from MS project files
I believe there are examples in either of these files. The xl97 version is
in the old windows help file format. The xl2000 one is in the Internet Explorer based help format used by office 2000 and later: http://support.microsoft.com/?id=167223 OFF97: Microsoft Office 97 Automation Help File Available (Q167223) http://support.microsoft.com/?id=260410 OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410) In any event, they do show you how to use Automation to control another application (that supports COM), such as MS Project. -- Regards, Tom Ogilvy "zouzou" wrote in message om... hi all , i need help to create a macro on excel which extract information from Ms project files , someone can give me some information or code of macro .... thanks in advance zouzou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I extract information from these websites onto Excel? | Excel Discussion (Misc queries) | |||
Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
project information into other cells | Excel Discussion (Misc queries) | |||
MS Project and Excel files too big | Excel Discussion (Misc queries) | |||
how do i extract information from excel and put in certain fields. | Excel Discussion (Misc queries) |