Just like to thank you NetDevil for writing this macro. I've used it successfully for a year or so with a sketch to measure the Ah capacity of lead-acid batteries with an arduino. Should have thanked you earlier. I found macros quite tricky to write so karma to you.
Hey NetDevil, Thanks a lot for the updates. I am trying to add more sensor values into different columns but am unable to do that. Do you have any suggestions for that.
Does anyone know how to get this working with a Mac? The ports for the Arduino are not listed in the same way "/dev/cu.usbmodem143101" etc. rather than "COM4" etc.
@NetDevil just discovered this, and already used it to take average measurements from my BME280 sensors.Just wanted to say thanks!!
Hello NetDevil, I am using PLX-DAQ, congratulations!!!.I´ve tried read the cell value and I would like to read the active cell. not its value. Could I do it with PLX-DAQ?
Hi Jason,good thing you pointed out yourself how spoon-fed the issue sounds - otherwise I might have done that The good news on the other hand is, that as long as your data can be posted to Serial Monitor in Arduino IDE it can be posted to Excel as well using PLX DAQ. All you have to do is replace your "Serial.println(yourOutputHere);" commands with the PLX DAQ syntax which basically is "Serial.println("DATA,ValueForColumnA,ValueForColumnB,ValueForColumnC,....,ValueForColumnX");You can read all about it in the Beginners Guide that is attached to the zip file or attached to the v2.11 post.Try starting with the default sketch and try to understand the syntax. All it does is spam data in a loop to Excel, just the same way you want to send data. Next step, try to change the data to some different values and the final step is to implement the data you have measured using your build.In case you have any specific questions rather then general ones please feel free to post here.GreetingsJonathan
I just have one last problem.Code: [Select]Serial.println( (String) "DATA,gsr_average,TIME,TIMER,AUTOSCROLL_20" );All of the above was able to be recorded in Excel like the time and timer except for the gsr_average value, instead it records the literal word "gsr_average" instead of the value. Am I doing something wrong here?
Serial.println( (String) "DATA,gsr_average,TIME,TIMER,AUTOSCROLL_20" );
Serial.println( (String) "DATA," + gsr_average + ",TIME,TIMER,AUTOSCROLL_20" );
Private Sub SpinButton1_Change()On Error Resume NextTextBox1.Text = SpinButton1.ValueEnd SubPrivate Sub TextBox1_Change()On Error Resume NextSpinButton1.Value = TextBox1.TextEnd SubPrivate Sub SpinButton1_SpinDown() TextBox1.Text = Val(TextBox1.Text) - 1End SubPrivate Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case vbKey0 To vbKey9, 8 Case Else KeyAscii = 0 Beep End SelectEnd SubPrivate Sub SpinButton1_SpinUp() TextBox1.Text = Val(TextBox1.Text) + 1End SubPrivate Sub SpinButton2_Change()On Error Resume NextTextBox2.Text = SpinButton2.ValueEnd SubPrivate Sub TextBox2_Change()On Error Resume NextSpinButton2.Value = TextBox2.TextEnd SubPrivate Sub SpinButton2_SpinDown() TextBox2.Text = Val(TextBox2.Text) - 1End SubPrivate Sub SpinButton2_SpinUp() TextBox2.Text = Val(TextBox2.Text) + 1End SubPrivate Sub TextBox2_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case vbKey0 To vbKey9, 8 Case Else KeyAscii = 0 Beep End SelectEnd Sub