Search found 12 matches

by john.hestia
Wed Nov 23, 2011 6:22 am
Forum: VB and VBA (Excel, Access)
Topic: Excel Hangs when reading on the ADC20
Replies: 0
Views: 3046

Excel Hangs when reading on the ADC20

Hi to All, How to get rid of this intermittent hang-ups? When running the macro on Excel at first time, it's ok. But after stopping the macro the run it again the Excel froze-out and the CPU usage stays in 100%. It never goes down if don't forcibly close the Excel. I think the caused is the ADC20, i...
by john.hestia
Tue Nov 22, 2011 7:10 pm
Forum: VB and VBA (Excel, Access)
Topic: ADC20 got Froze out!
Replies: 0
Views: 2811

ADC20 got Froze out!

Hi to all, Anyone got an experienced with ADC20, when reading the value from all channels then it got froze? I am using Excel VBA to get that data from ADC20, it reads the first four channels then got stuck on the last four channels... therefore I need to close the excel forcibly because it's not re...
by john.hestia
Tue Nov 22, 2011 7:38 am
Forum: USB PC Data Loggers
Topic: Lost Excel device connection / example files
Replies: 9
Views: 6101

Re: Lost Excel device connection / example files

Thank you very much Martyn!
Now are clear to me!


Regards,
John
by john.hestia
Mon Nov 21, 2011 11:19 am
Forum: USB PC Data Loggers
Topic: Lost Excel device connection / example files
Replies: 9
Views: 6101

Re: Lost Excel device connection / example files

Hi Martyn, Ok that is fine, I will read it again the programmers guide... My other question is, what is the value of "value"? I mean what kind of value, is that a decimal only, binary, milivolts, or other? Like on HRDL.xls when I run the macro Function adc2mV(value As Long) As Long adc2mV = value * ...
by john.hestia
Mon Nov 21, 2011 8:34 am
Forum: USB PC Data Loggers
Topic: Lost Excel device connection / example files
Replies: 9
Views: 6101

Re: Lost Excel device connection / example files

Hi Martyn,

I had the hrdl.xls already, and it's only taking the data of HRDLGetTimesAndValues. How about another example for the other functions?

Thank you and Regards,
John
by john.hestia
Sun Nov 20, 2011 12:32 pm
Forum: PicoLog
Topic: ADC 20 Dynamic Data Exchange(DDE)
Replies: 0
Views: 2107

ADC 20 Dynamic Data Exchange(DDE)

Hi to All,

Guys, do you have any idea how to capture all the calculated parameters in PLW Recorder? When I tried this DDE to Excel I only got the Channel1, and I did not get the Room temperature...
by john.hestia
Sun Nov 20, 2011 6:23 am
Forum: USB PC Data Loggers
Topic: Lost Excel device connection / example files
Replies: 9
Views: 6101

Re: Lost Excel device connection / example files

Hi Ziko,

Can you please give us the link of sample excel vba code? Or this is the same with the HRDL.xls sample? But if you have another examples of excel vba code for ADC20, please give us the download link.

Thank you and Regards,
John
by john.hestia
Sat Nov 19, 2011 6:47 pm
Forum: VB and VBA (Excel, Access)
Topic: Multiple ADC20 units running
Replies: 12
Views: 13910

Re: Multiple ADC20 units running

Hi to All, I am new in programming, totally new and I just started the "Hello World" of Excel VBA. If someone who is so generous to share their code for my reference to build my own excel vba. We just want to get the temperature using the LM35 connected to ADC20. So much appreciated your help. Thank...
by john.hestia
Sat Nov 19, 2011 10:57 am
Forum: VB and VBA (Excel, Access)
Topic: function adc2m
Replies: 2
Views: 3471

Re: function adc2m

Thank you very much Martyn!
by john.hestia
Thu Nov 17, 2011 10:17 pm
Forum: VB and VBA (Excel, Access)
Topic: function adc2m
Replies: 2
Views: 3471

function adc2m

Function adc2mV(value As Long) As Long

' calculate value depending on number of bits
adc2mV = value * 2500000# / 8388608

End Function


Hi to Anyone,

Please explain what is the meaning of function above, appreciate your prompt reply.
by john.hestia
Mon Nov 14, 2011 10:34 am
Forum: PicoScope 5
Topic: HRDL.xls
Replies: 3
Views: 5514

Re: HRDL.xls

Hi Martyn, Addition to my question, how to get the data from PLW Recorder Spreadsheet exactly the same what am I looking on the screen? I tried saving it on txt file and I only get one line but in PLW Recorder Spreadsheet there are lots of data scrolling. Or is there a way to save the captured data ...
by john.hestia
Mon Nov 14, 2011 9:54 am
Forum: PicoScope 5
Topic: HRDL.xls
Replies: 3
Views: 5514

Re: HRDL.xls

Thank you Martyn!