Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically extracting MS Project data for use in Excel
Hi All,
Potentially a tricky one (not least because I might be going about doing it in a bit of a backwards way)... I've got a large amount of data in a MS Project file, which is too much to be able to be able to use as a summary document. To this end, I've created a series of macros which use the project data to prodcue summary charts and graphs as required - this is done and dusted with... The bit that remains, and that I'm struggling with, is how to simplify the process. I want a single button, in excel, that when pushed does the following: 1. Opens up hte relevant Project file 2. extracts the required fields (for example, name and start date) from that project file and saves them elsewhere in the workbook. 3. closes back up the project file - and lets my other macros do their magic on the resultant data... To be honest, I can' t do any of these - but I'm particularly stumped by 2. I've thought about trying to save the data in project as an .xls (using a template as required), or getting excel to run some macro in Project which could do the extract.... Any help with these or examples of bits of code that might help would be fabulous! Thanks in advance.... Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting information to automatically find previous value. | Excel Worksheet Functions | |||
Automatically extracting unique values | Excel Worksheet Functions | |||
Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming | |||
Extracting Data from External Source - Automatically | Excel Programming |