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...

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...

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


Regards,
John

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 * ...

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

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...

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

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...

Thank you very much Martyn!

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.

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 ...

Thank you Martyn!