Page 1 of 1

DPlotJr Excel add-in not working

Posted: Thu Dec 19, 2013 7:21 am
by Fred
I am trying to install the Excel add-in on a new laptop but the installation fails when the VBA code execution starts (workbook_open function):
System error &H80070057 (-2147024809) Wrong parameter
Out of memory

It's a Windows 7 64b machine with 16Gb of RAM.

Any clue on the parameter to look at?

Thx.

Posted: Thu Dec 19, 2013 11:33 am
by DPlotAdmin
That sounds like something must be corrupted (assuming the error message is correct). There's really not any memory allocation going on in the workbook_open function - all it does is create the Add-In menu.

I'd first try re-installing. If that doesn't help and you're feeling adventurous, click the Developer tab, then "Visual Basic" on the far left. In the VB window click the + sign next to dplotlib.xla. If prompted for a password use "DPlot". Select Microsoft Excel Objects -> ThisWorkbook. You'll see "Private Sub Workbook_Open()". Change the name to some nonsense, e.g. Bookwork_Open() so that it isn't called. Save and then exit and restart Excel. You won't have a DPlot Add-In menu and will have to access the various Add-In functions from the Macros menu, but it might tell us more about what is going on.