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