Results 1 to 2 of 2

Thread: Excel And Perfmon

  1. #1

    Excel And Perfmon


    I am trying to use the perfmon performance monitoring recommended in the book Professional Excel development.

    I was able to successfully regsvr32 the following file:


    When I tried to regsvr32 these files I got


    I get this error:

    [Window Title]

    The module "perfmonoffice.dll" was loaded but the call to DllRegisterServer failed with error code 0x80004005.

    For more information about this problem, search online using the error code as a search term.


    When I try to call the PerfmonStartMonitoring method in my VBA code I get this error:

    Microsoft Visual Basic for Applications
    Run-time error '429':

    ActiveX component can't create object
    OK Help

    Has anyone used Perfmon before to monitor the speed of their VBA procedures and how can I get it working?

    I'm using Windows 7 64 bit with Excel 2013 64 bit.

    Looking forward to your reply.


  2. #2
    Knowledge Base Approver VBAX Guru
    Apr 2012
    I would never add an application that slows down the performance of my VBA solutions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts