View previous topic :: View next topic |
Author |
Message |
gtg590x
Joined: 01 Feb 2010 Posts: 1
|
Posted: Mon Feb 01, 2010 12:13 pm Post subject: Excel Add-in Run-time Error 9 |
|
|
I have a 180x180 table of values in excel which I want DPlot to create a surface plot for. I've tried using the excel add-in call for a ZGrid and a ZScatterTable but both kick back the same VBA error. The error is in excel and the DPlot window stays empty.
Quote: |
Run-time error '9':
Subscript out of range |
I've gotten the ZGrid call to work by cutting my table down to 100x100, but if I change any of the x or y axis values I get the same Run-time error.
I'm using excel 2007 in XP x64. DPlot version 2.2.7.7
I've tried searching the forum for the run-time error but I couldn't find anything. Any help with this problem would be appreciated. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Mon Feb 01, 2010 1:14 pm Post subject: |
|
|
I tried an example with a 180x180 grid just now, and it worked fine for me. Looking at the ZGrid code I don't see anything that is data-specific that would cause a problem, but I've been wrong before. At your convenience please send me your spreadsheet. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Mon Feb 01, 2010 6:37 pm Post subject: |
|
|
Thanks for your file - that was very helpful.
There's a goof in the ZGrid and ZScatterTable functions in the new Add-In that results in an unhelpful "Runtime Error 9" if either X or Y are not evenly-spaced. I'll be making a full update later tonight, but there's no reason for you to wait.
Exit Excel if it is running. Get http://www.dplot.com/excel/dplotlib.xla and save to %APPDATA%\Microsoft\AddIns, overwriting the existing copy.
I apologize for any inconvenience this problem caused. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Mon Feb 01, 2010 7:51 pm Post subject: |
|
|
Ryan: By the way mail sent to your reply-to address was rejected. I'm not sure if that's a goofy setup for your mail or a whitelist-thing. In any case, my reply to the second part of your mail was:
On your other problem, it sounds like you're running multiple accounts on
the same system - yes? If so you can get around this problem by copying
%APPDATA%\DPlot\dplot.ini to %ALLUSERSPROFILE%\DPlot _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
|