lostin_space
07-31-2006, 05:53 AM
hi all - has anyone had any experience interfacing Excel & MS Project?
I'm trying to create a report, that will pull resource data into excel from MS Project.. i've found some sample vba code that spits data out of project to excel, but only when you're in / using ms project - and then it dumps it into a new worksheet.
But the whole thing's 'the wrong way round', and no amount of tweaking seems to make it work. (we've had 3 of us crowded round a screen, offering ideas on this one!)
In base terms, what i need to do is this :-
a) prompt users to 'browse' for the relevant project .mmp file
b) pull out of the file, all the 'resource used' data from the .mmp (without opening)
c) drop all data found (in plain text) into a new worksheet for further processing
has anyone got any ideas / seen examples / ever done this??
:dunno there seems to be relatively little info available about mixing excel & project....
Tia
Russ
:doh:
I'm trying to create a report, that will pull resource data into excel from MS Project.. i've found some sample vba code that spits data out of project to excel, but only when you're in / using ms project - and then it dumps it into a new worksheet.
But the whole thing's 'the wrong way round', and no amount of tweaking seems to make it work. (we've had 3 of us crowded round a screen, offering ideas on this one!)
In base terms, what i need to do is this :-
a) prompt users to 'browse' for the relevant project .mmp file
b) pull out of the file, all the 'resource used' data from the .mmp (without opening)
c) drop all data found (in plain text) into a new worksheet for further processing
has anyone got any ideas / seen examples / ever done this??
:dunno there seems to be relatively little info available about mixing excel & project....
Tia
Russ
:doh: