Performance code ms excel/ms project RRS feed

  • Question

  • I have a macro in Excel, it opens a ms project plan and copies all data to excel, consolidating on average 1000 lines of at least 20 different plans (like Work, Actual Work, categorized by custom fields).

    Problem: Performance

    I would like to know any way to Improve the performance of this reading project, as in excel, it is Possible to disable a number of limiting factors That Improve the performance of the macro.

    Thank you for your help!

    Diogo Araújo Administrator Tools Programmer Accenture Brazil

    Monday, March 26, 2012 7:36 PM

All replies

  • Hi Diogo,
    Thank you for posting. 
    I will help you involve others to help you. There might be some delay about the response. Appreciate your patience.
    Best Regards,

    Bruce Song [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, March 28, 2012 7:54 AM
  • Hi Diogo,

    For performance issue, one would need a benchmark as target. So how fast do you expect the code should running? What about the actual time it takes to run? Accurate data would help all through this discussion.

    best regards,

    Forrest Guo | MSDN Community Support | Feedback to manager

    Wednesday, March 28, 2012 9:29 AM