View Single Post
  #1 (permalink)  
Old July 19th, 2004, 04:01 AM
James Diamond James Diamond is offline
Authorized User
Join Date: Jan 2004
Location: , , .
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do I debug an ActiveX DLL referenced by Excel?


I am writing a DLL with VB6 that is used by an Excel spreadsheet. When I run the spreadsheet, it passes values from the sheet to functions in the DLL. The DLL stores hundreds of values in arrays.

What is the best way of seeing those values? Currently I am writing additional "debug" functions to write the values back to the spreadsheet, but this is dreadfully time-consuming.

Is there a debugger that will enable me to interrogate variable arrays etc. in the DLL *during* the running of the VBA in the spreadsheet?

Your guidance is appreciated.



Reply With Quote