I was wondering if any one has an example of "SAVEWORKBOOK" or "SAVEWORKBOOKAS" that is working, I've built it out a few different ways but havn't got it to work properly. I'm just testing the PLX-DAQ on my arduino uno wifi rev2, i have a DHT11 sensor hooked up just to mess around with, I can get it to log to the excel file no problems. Just can't quite figure out how to get it to save the file properly on its own. This would be handy as then i can pull the data in on another excel file on a different computer.
|10:40:58 PM| RESUMELOGGING
SYS: |10:40:48 PM| ## ERROR within command ! ## 1004 / Method 'Save' of object '_Workbook' failed
|10:40:48 PM| SAVEWORKBOOK
|10:40:38 PM| PAUSELOGGING
This is the error in the Debug i'm getting, I must not be referencing something right there, any help would be appreciated
Here is my bit of code executing the data and the save command
Serial.print("DATA,TIME,"); Serial.print(t); Serial.print(","); Serial.println(h);
delay(5000);
Serial.println( "PAUSELOGGING" );
delay(10000);
Serial.println( "SAVEWORKBOOK" );
delay(10000);
Serial.println( "RESUMELOGGING" );