ms project

  1. S

    Display the text before the 6th instance of a period in a string (MS Project or VBA)

    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...
  2. S

    Calculate Project Allocations

    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...
  3. J

    MS Project VBA Calendar question

    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...
  4. D

    I need to write following Excel formulas in MS Project. Could you please help?

    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...
  5. S

    VBA - Exporting Timeline Info from Excel to MS Project

    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...
  6. Z

    Help with VBA code to extract information from MsProject to MsExcel

    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...
  7. E

    Misunderstood Type Mismatch Error

    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...
  8. M

    Use VBA to Import Data into Excel from MS Project 2013

    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...
  9. K

    Duration Calculation

    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...
  10. M

    Prevent Open Resource Pool Dialogue box when opening MPP Project File using VBA

    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...
  11. A

    Excel and Project seize

    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...
  12. E

    Extracting Numbers out of a String from MS Project

    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...
  13. H

    MS Access Dates in MS Project

    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...
  14. M

    Linking MS Project to excel

    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...
  15. M

    Active links from project to excel

    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...
  16. M

    Running resource reports from a Master schedule

    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...
  17. L

    Import outline levels into Excel

    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...
  18. C

    Convert Text to Table?

    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.
  19. I

    remove references programmatically & how to prevent debug error

    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: this works fine if the user has...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back