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
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