DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel Add-in Run-time Error 9

 
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports
View previous topic :: View next topic  
Author Message
gtg590x



Joined: 01 Feb 2010
Posts: 1

PostPosted: Mon Feb 01, 2010 12:13 pm    Post subject: Excel Add-in Run-time Error 9 Reply with quote

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
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2095
Location: Vicksburg, Mississippi

PostPosted: Mon Feb 01, 2010 1:14 pm    Post subject: Reply with quote

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.
_________________
David Hyde
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2095
Location: Vicksburg, Mississippi

PostPosted: Mon Feb 01, 2010 6:37 pm    Post subject: Reply with quote

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.
_________________
David Hyde
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2095
Location: Vicksburg, Mississippi

PostPosted: Mon Feb 01, 2010 7:51 pm    Post subject: Reply with quote

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
_________________
David Hyde
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group