Example .XLS program crashes when # 0f samples exceeds 100

 
Post new topic   Reply to topic    Pico Technology Forum Index -> VB and VBA (Excel, Access)
Author Message
brucegsun
User
User


Joined: 25 Apr 2007
Posts: 2
Location: Fredericksburg, Virginia

PostPosted: Wed Apr 25, 2007 2:51 pm    Post subject: Example .XLS program crashes when # 0f samples exceeds 100 Reply with quote

I having problems getting the example program to handle more than 100 samples. In my application, I'll need at least 50,000 samples. I'm using the original time base of 13. The program crashes any time I do one of two things, when I increase no_of_samples value above 100 and if I increase "i" in the for next loop after the ps3000_get_times_and_values command. Is this an Excel problem or a ps3000 set up problem? I have attached the modified example .XLS file with the VBA code. Thank you very much for your time and assistance.


ps3000-2.xls
 Description:

Download
 Filename:  ps3000-2.xls
 Filesize:  73 KB
 Downloaded:  141 Time(s)

Back to top
markspencer
Site Admin
Site Admin


Joined: 07 May 2003
Posts: 607

PostPosted: Thu Apr 26, 2007 7:45 am    Post subject: Reply with quote

Hi,

When you change the number of readings to 50,000 you will also have to change the arrays as well....

ReDim values_a(50000) As Integer
ReDim values_b(50000) As Integer
ReDim values_c(50000) As Integer
ReDim values_d(5000) As Integer
ReDim times(50000) As Long

Best regards,
Mark S.
Back to top
brucegsun
User
User


Joined: 25 Apr 2007
Posts: 2
Location: Fredericksburg, Virginia

PostPosted: Fri Apr 27, 2007 9:26 am    Post subject: Reply with quote

Thank you for your kind assitance. The program works fine now. I appreciate your help.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> VB and VBA (Excel, Access)
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group