ms project

Hello! I'm trying to figure out a macro that can display the text before the 6th instance of a period in a string. =TEXTBEFORE(".",6) works perfectly in Excel but I need this to work in MS Project and I don't know of a formula that will do this using MS Project's list of commands. If this is...

I have a dataset with a person name, project name, allocation % for that project (say 25%) and start and end dates (say 6/1/22 to 9/30/22). So I know this person is allocated 25% across the duration of this project for 4 months, which tells me this person has only availability of 75% during...

I got this code below which populates the Standard calendar with public holidays. Can anyone point my in the right direct to do the same onto a resources calendar. Example resource calendar name = "Joe Bloggs" here is the code I've got working. Sub Create_New_Exceptions() Dim e As Exception...

Hello Everyone, I need help from you to write formulas in MS project. I had a file in Excel. But I need to use MS Project because of management decision. MS Project formula language is different and I do not have any experience about it before. I will be really glad if you can help me about it...

Hi, I have a tool I've developed in Excel that ends up building a particular 'timeline' out. Its columns look somewhat like the following: ActivityID Description Duration StartDate EndDate It builds out this 'timeline' using inputs gathered from the user in an excel userform, and then...

Hey everyone, I am trying to extract information from project to excel and do this via code. This is something that has to be continuously done as the project rolls on so doing it manually will take too much time. I have posted the code below that I have managed to piece together via perusing...

This code throws a type mismatch error on the second loop through at Do While Selection.Value <> "". I have no idea what's causing this. Any ideas? Thank you for your time! Sub OpenProjectCopyPasteData2() Dim PrjApp As MSProject.Application Dim aProg As MSProject.Project Dim...

I am creating a dashboard in excel to display the status of many projects managed separately in MS Project. I would like to automatically import column headers and data from MS Project directly into a specified sheet within the dashboard workbook each time it opens. Does anyone have experience...

I am looking for VBA code to perform the following task.. I have a column for baseline duration, a column for duration and a column for production coding. I need code to auto figure the following… duration = baseline duration * production coding. My issue is that both the duration and...

Hi </SPAN></SPAN> I have some code that I am using to Open a Microsoft Project file but despite all efforts I have been unable to prevent the opening dialogue box from appearing or auto answering it.</SPAN> i.e. "Open resource pool read-only allowing others to work on projects connected to...

I am trying to get excel to open a MS Project file and then run a project macro on it. What is happen is that when I run my code it works, and then excels VBA window freezes up and the run arrow goes away, and if I try to open project I just get a chiming noise and it won't open. For now I...

Hello All, I’ve been trying to collect some data from a consolidated MS Project file. When I export to Excel all of the durations are in the format (4.5 days, 6 days, 18 days, etc.). In order to perform statistical analysis in Excel I need just the numbers. I’ve tried looking into MID and...

Hey, I am using Access 2010 on Windows 7. I have a form on access with multiple inputs, but specifically it has 6 start and end dates (3 of each) that I would like to add to a project in MS Project. I would like to be able to set up a button that, when clicked, opens MS project to an already...

Hello, I'm trying to establish active links from an MS project document to an excel spreadsheet. Through copying and pasting specials I'm managing dumb values and Hyperlinks to the document, neither of which are what I'm after? Does anyone know how to create the links I'm after? the...

Hello, I'm trying to link an MS project docuement to an excel spreadsheet to allow monitoring of the progress of the project and I'm having trouble establishing the links. I'm either getting dumb values or a hyperlink that opens up the project document. Does anyone know how I can establish...

Hello. In Microsoft Project, I am trying to run a resource usage report from a master project plan comprised of 10 projects. When i use the standard resource usage report the output is name, task, and hours per week over x weeks. I am looking for a report that will show me name, project and...

Is there a way to import the outline levels into Excel? My challenge is that I am attempting to import MS Project information into Excel. I export the Outline Level (1, 2, 3, etc) with my other fields from Project. I know how to use the Outline Level to add spaces and create the right visual...

Does anyone know the syntax to convert text to table using 2 delimiters (~ to switch to the next column and "&" to switch to the next row)? I'm planning to use it as part of a macro for MS Project 2003 but I figure it would be pretty much the same in excel. Any help would be greatly appreciated.

hi excel gurus! i m working on an excel 2007 workbook with ms project functionality. in order to be able to use ms project from within excel i m using early binding. for those who dont know what early binding is: http://www.dicks-clicks.com/excel/olBinding.htm this works fine if the user has...