Consulting

Results 1 to 2 of 2

Thread: Excel And Perfmon

  1. #1

    Excel And Perfmon

    Hi,

    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:

    PerfMonitor.dll

    When I tried to regsvr32 these files I got

    PerfMonOffice.dll
    PerfMonVB6.dll

    I get this error:

    [Window Title]
    RegSvr32


    [Content]
    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.


    [OK]

    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.

    Matthew

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Apr 2012
    Posts
    4,893
    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
  •