Guys I work in MSp my surveyors work in excel, I want to give them a work package procurement schedule in excel that is based on the MSP procurement schedule. the schedule is a list of activities from tender information through to start on site (sorry for the sucking eggs part, just in case someone didnt get it). I know this can be done with VBA - but I do not know how to programme in VBA and I do not have the time - I am being pressed for some answers. Is there anybidy out there that can give me some coding that would do this?. I know I should go purchase Rods book, but as I have said I am pushed at the moment. If anyone is feeling generous it would reaaly be appreciated, anyway thanks in advance Andrew
The solution may be easier than you think. Create a filter in MS Project that shows only the tasks you want to export. You may need to do it one Work Package at a time. Use the Analyze Timescaled Data in Excel wizard from the analysis toolbar. This will export useful information for you. See if that helps. If not, please post a more specific question. Glad to help. -- If this post was helpful, please consider rating it. Jim Check out my new blog for more information: http://www.msprojectblog.com "Andrew" wrote: > Guys > > I work in MSp my surveyors work in excel, I want to give them a work package > procurement schedule in excel that is based on the MSP procurement schedule. > the schedule is a list of activities from tender information through to start > on site (sorry for the sucking eggs part, just in case someone didnt get it). > I know this can be done with VBA - but I do not know how to programme in VBA > and I do not have the time - I am being pressed for some answers. Is there > anybidy out there that can give me some coding that would do this?. I know I > should go purchase Rods book, but as I have said I am pushed at the moment. > If anyone is feeling generous it would reaaly be appreciated, anyway thanks > in advance > > Andrew
Cheers Jim I will give it a go and get back to you Regards Andrew "Jim Aksel" wrote: > The solution may be easier than you think. Create a filter in MS Project > that shows only the tasks you want to export. You may need to do it one Work > Package at a time. > > Use the Analyze Timescaled Data in Excel wizard from the analysis toolbar. > This will export useful information for you. > > See if that helps. If not, please post a more specific question. Glad to > help. > -- > If this post was helpful, please consider rating it. > > Jim > > Check out my new blog for more information: > http://www.msprojectblog.com > > > > "Andrew" wrote: > > > Guys > > > > I work in MSp my surveyors work in excel, I want to give them a work package > > procurement schedule in excel that is based on the MSP procurement schedule. > > the schedule is a list of activities from tender information through to start > > on site (sorry for the sucking eggs part, just in case someone didnt get it). > > I know this can be done with VBA - but I do not know how to programme in VBA > > and I do not have the time - I am being pressed for some answers. Is there > > anybidy out there that can give me some coding that would do this?. I know I > > should go purchase Rods book, but as I have said I am pushed at the moment. > > If anyone is feeling generous it would reaaly be appreciated, anyway thanks > > in advance > > > > Andrew
