ms project

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. 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: http://www.dicks-clicks.com/excel/olBinding.htm this works fine if the user has...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top