PDA

View Full Version : Excel And Perfmon



MatthewNYC
03-23-2017, 05:05 PM
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

snb
03-24-2017, 02:26 AM
I would never add an application that slows down the performance of my VBA solutions.