PLX-DAQ version 2 - now with 64 bit support! (and further new features)

[NetDevil]

ralphjabonga:
I just want to directly write serial monitor values to excel i downloaded all versions. v2 v2.2 v2.3
I dont get whats the correct code. when i clicked connect nothing changes. com3 was recognize where my arduino was connected

Hi ralphjabonga,

the Serial.print statements in your code are written to output to the serial monitor of Arduino IDE. To see the results in Excel, please:

• Download the latest version 2.6 above
• Connect your Arduino to your PC, click on Connect and open the "direct debug window"
• You should now see the serial.print statements as in Arduino IDE serial monitor
• To have it being posted to Excel you need to use the PLX DAQ syntax. Examples can be found here Arduino and real time charts in Excel « Robottini or here http://www.instructables.com/id/Sending-data-from-Arduino-to-Excel-and-plotting-it/?ALLSTEPS and of course in the example sketch attached to the zip file of version 2.6
• Basically you just need to send 1) CLEARDATA first, 2) followed by LABEL and the name of the columns you want to have in Excel and 3) send DATA followed by the t and h values you measured

It is pretty simple, just take a look at the examples I provided

Greetings

[ankoo]

please help me..

Win10 and office13

all time with all version program have the same problems

[NetDevil]

ankoo:
Win10 and office13

Hi Ankoo,

are you running Win10 on 64bit or 32bit ?
same for Office 2013: 64 or 32 bit?

[jl1cny]

Hi Net Devil

Thank you very much for providing a great handy tool to transfer serial data to Excel. I am writing a sketch that controls Arduino by sending characters and numbers to it through serial. I am wondering if you can add functions to PLQ-DAQ version 2 that allows the user to send characters and numbers to Arduino through serial.

My project is to build a sweep frequency generator with a power detector. One can control the frequency range of the signal generated and the output of a filter under measure is measured and sent back to EXCEL to draw a graph.

Thank you in advance for your consideration.

Best regards,

Sam

[NetDevil]

jl1cny:
Thank you very much for providing a great handy tool to transfer serial data to Excel. I am writing a sketch that controls Arduino by sending characters and numbers to it through serial. I am wondering if you can add functions to PLQ-DAQ version 2 that allows the user to send characters and numbers to Arduino through serial.
(...)
Thank you in advance for your consideration.

Hi Sam,

thanks a lot for your feedback Good news for you: the function is in fact already present in the program

With the command

Serial.println("CELL,GET,D1,");

your Ardunio can ask Excel to send him the values from cell D1 (well in this case). In that cell (and further cells) you could put the variables that you use to operate the frequency range.

Otherwise you could use the custom dev-point "CustomDevPointNewData". There you could easily send your own defined commands from Arduino to Excel and programm in VBA any behaviour you want (e.g. check current time of PC and adjust frequency if time is pre 12:00 am or past 12:00 am. Data can be send to your Arduino from VBA via command

CommWrite cboPort.Text, "Any information can be send here"

In case you have any further questions please feel free to ask

Greetings

NetDevil

[jl1cny]

Hi NetDevil,

Thank you for the quick response. It is great to know the function is already there!
I tried CELL GET function and came up with a few more questions.

1. I tried the code below with 123 in D1. When executed, the EXCEL says "Value in cell D1=0" in A2. It seems the value in D1 is not properly read. Any problem with the code?

Serial.println("ROW,SET,2");
Serial.println("CELL,GET,D1,");
Serial.print("DATA,");
int cell_num = Serial.parseInt();
Serial.print("Value in cell D1 = ");
Serial.print(cell_num);
Serial.println(",");

2. I want to copy a number in C1 to D1. Then I tried the code like this. I found 'a' in D1. What I meant is to see the number in C1 copied to D1. How can I do it?

Serial.println("CELL,GET,C1,");
int a=Serial.parseInt();
Serial.println("CELL,SET,D1,a,");

3. I would like to clear contents for the range of say A2 to B200. How can I do it?

Thank you very much in advance for your help.

best regards,

Sam

[NetDevil]

Hi Sam,

well - let's see.

1. I guess you used Larrys code from here PLX-DAQ version 2 - now with 64 bit support! (and further new features) - #18 by LarryD - Interfacing w/ Software on the Computer - Arduino Forum ? Have you tried running the whole sketch and then stripping down to what you need?

From what I see instantly is, that you have two much commas in your code.

Serial.println("ROW,SET,2");
Serial.println("CELL,GET,D1,"); <<<== last comma after D1 is too much
Serial.print("DATA,");
int  cell_num = Serial.parseInt();
Serial.print("Value in cell D1 = ");
Serial.print(cell_num);
Serial.println(","); <<<== full line needless. Just change above line to Serial.println(cell_num);

2. Sure it puts an "a" in the cell. You send an "a" hardcoded Change to:

Serial.println("CELL,GET,C1,");  <<== last comma needless again
int a=Serial.parseInt();    
Serial.print("CELL,SET,D1,");
Serial.println(a); <<== use variable 'a' instead of char 'a' in string above

3. No, there is no function yet to clear a range. By the command CLEARSHEET you can clear the full sheet. What you can do is

a) loop in your Arduino and clear the cells yourself

for(int i = 2 ; i <= 200 ; i++)
{
  Serial.print("CELL,SET,A");
  Serial.print(i);
  Serial.println(",")  <<<=== used to output 'CELL,SET,A2,' ; last comma needed to say fourth parameter (aka value) is empty, thus cell A2 should be made empty
  Serial.print("CELL,SET,B");
  Serial.print(i);
  Serial.println(",") <<<=== same for cells B
}

(please note! I have no Arduino here with me right now. Code is from mind, hopefully the syntax is ok)

That method is dirty. Better would be to define your own command and use it in the custom dev point CustomDevPointLineRead as recommended above.

Arduino code with new function and parameters:

Serial.println("MyCustomClearCommand,A,2,B,200");

VBA code extension in Excel (press F11 to get to VBA code editor in Excel) in the module frmStampDAQ (right click 'Show code'):

Private Function CustomDevPointLineRead(newLine As String) As Boolean

    CustomDevPointLineRead = True 'be true if not stated otherwise in this function
    Dim DataVal() As String

If Data <> "" Then
    DataVal = Split(Data, ",")
    If (UCase(DataVal(0)) = "MYCUSTOMCLEARCOMMAND") Then
        WStoUse.Range(WStoUse.Cells(DataVal(2), DataVal(1)), WStoUse.Cells(DataVal(4), DataVal(3))).ClearContents
        'line above translates to = Range(Cells(2,A),Cells(200,B)).ClearContents
        CustomDevPointLineRead = False
        'line above says that command was operated and no need to pass to main function
    End If
End If

End Function

The Range-clear-Command could be useful for many people so maybe I should integrate it into the standard and release with version 2.7. However that way you should be able to use it now already.

[jl1cny]

Hi, NetDevil

Thank you for your quick reply as always. I appreciate it.

As for 2. and 3., it works fine. Although you said 3. a) is dirty, it showed me a way to overwrite data in certain range, which is more suitable for my purpose than clearing contents then filling data. Thank you soooo much! I am looking forward to seeing new Range-clear-Command incorporated into Ver 2.7 in the near future, though. This tool is going to be a perfect solution to me.

What is still annoying me is 1. As you suggested, I just copied and pasted LarryD's entire code and ran it with no joy. It seems to me that his code works properly except GET function. Then I tried Ver 2.4, which I believe he used for his code. No joy. Then I changed his code based on your suggestion still with no joy. I am totally lost. Any idea? I really want to use his tool.

Best regards,

Sam

[NetDevil]

jl1cny:
What is still annoying me is 1. As you suggested, I just copied and pasted LarryD's entire code and ran it with no joy. It seems to me that his code works properly except GET function. Then I tried Ver 2.4, which I believe he used for his code. No joy. Then I changed his code based on your suggestion still with no joy. I am totally lost. Any idea?

Hi Sam,

I tried using my Arduino and your code is working fine for me as long as I read numbers(!). Reading chars or strings is not working because of the used

Serial.parseInt();

In case you want to read chars / strings try this one:

Serial.println("ROW,SET,2");
Serial.println("CELL,GET,D1");
Serial.print("DATA,");
String cell_content = Serial.readString(); <<== Changed data type, variable name and Serial-function
Serial.print("Value in cell D1 = ");
Serial.println(cell_content); <<== used new variable nane

The command for ClearRange is already included in v2.7 which I will release in the next post (in a few minutes)

[NetDevil]

As announced here we are (new post for clear hyperlinking):

---

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

---

What's new in "version 2.7" aka Change log:

• Added a new command: ClearRange that allows for a range to be cleared in the sheet.
  Syntax is Serial.println("ClearRange,StartColumn,StartRow,EndColumn,EndRow"); ==> e.g., Serial.println("ClearRange,B,2,D,50");
• fixed a bug when closing the form while still logging. The macro was not paused correctly but will do so now

Backlog for next version(s):

• find a good solution for Excel crashing when moving the window around while logging. Priority: low

I also updated the example sketch once more with the ClearRange command (included stand alone and in the zip file as well).

Image-Link: http://www.freebie-base.de/Pics/PLX_DAQ_v2.7.png
(hosted on my server, no traffic hijack)

What's new in "version 2.6" aka Change log:

• Fixed the reset timer button (there was a useless message box implemented somehow)
• Formatted the timer to always have 6 trailing digits
• removed the old fashioned limit to 27 columns - now supports the thousands of columns that Excel supports (although it is getting pretty slow with too many columns)
• Set the columns all to be aligned centrally on default and column captions to be written in bold by default
• and well yeah - added the warning remark not to play around too much with the window during logging

What's new in "version 2.5" aka Change log:

• Added a "Pause logging" / "Resume logging" button that can (well no surprise) stop the logging of the data without disconnecting the Arduino. The Button is enabled when connected

• Removed the old 4 checkboxes as the functions are useless without Stamp nowadays and replaced with 3 custom checkboxes. As with old PLX DAQ v1 these checkboxes can be controlled by Arduino code: change text, check/uncheck box, read status of boxed (if checked or not). Codes changed from "DOWNLOAD" / "STORED" / "USER1" to CUSTOMBOX1 / CUSTOMBOX2 / CUSTOMBOX3. "USER2" was removed completely.

• Moved "Reset on Connect" around a bit for better UI layout

• Re-implemented the code for "Reset Timer" button. I don't know why I removed that anyways in version 2.1 ....

• I added a new example sketch that demonstrates the new functions and how one can use them

• I also rework the example codes in the custom dev points for not crashing Excel anymore - hopefully

• Added new functions to call in Excel by Arduino:

• Beep : makes a simple beep

• Pauselogging : stops printing logged data to the Excel sheet

• Resumelogging: continues pasting data again

• Stoplogging : disconnects the Arduino

• Saveworkbook : simply saves the workbook

• SaveworkbookAs,Filename : saves the workbook as a new copy in the same folder by the name Filename.xlsm

• ForcequitExcel: forces Excel to close. Note: the workbook will not be saved by this!

What's new in "version 2.4" aka Change log:

• Fixed a UI problem with Office 365
• Implemented 2 "custom dev points" ("new line was read" and "new data row recognized") which get called by the system automatically and where custom code can be pasted and used (example included in code)

What's new in "version 2.3" aka Change log:

• Port and baud rate not drop down box anymore but free text fields
• Port number bug fixed thus ports > 10 can be used (max set to 256 as of modern Windows OS limit)

What's new in "version 2.2" aka Change log:

• Enhanced 64 bit support (even better stability now)
• Added a dropdown box to select with sheet to post to (got rid of the radio buttons)
• Minor adjustment for faster startup of logging

What's new in "version 2.1" aka Change log:

• --- version never released ---
• --- it was more of an "internal development version"

What's new in "version 2":

• Support for both Office versions 64 bit as well as Office 32 bit
• No more installation needed! All within the workbook
• I got rid of the selmaDAQ_Ver2.ocx and use API calls now
• Fully compatible to all previous PLX-DAQ commands in your code!
• Got rid of some old stuff like "Max row size of 65000" (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
• Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
• Setting for selecting where to post data (first most left sheet or currently active sheet)
• Disabled the control boxes as Stamp object is no more in use

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

PLX-DAQ-v2.7.zip (136 KB)

PLX-DAQ-v2-DefaultSketch.ino (2.19 KB)

[el_supremo]

a minor fix. There's a missing end quote in the example in your post (49):

Serial.println("ClearRange,B,2,D,50);

Pete

[NetDevil]

el_supremo:
a minor fix. There's a missing end quote in the example in your post (49):

Serial.println("ClearRange,B,2,D,50);

Pete

Thanks, I fixed it.

[jl1cny]

Hi,

Thank you for uploading Ver2.7! The new function works very well.

I am still investigating the reason GET function does not properly work in my Arduino.

I just created a simple sketch below to see if the 123 in E2 will be copied to D2 and 'TEST' in E3 will be copied to D3. When executed, it is weird enough to see 0 in D2 and 123 not 'TEST' in D3. It seems to me as if the data transfer from the EXCEL to my Arduino was delayed so that 123 which should be input to variable 'b' was actually input to variable 'd'.

Serial.println("ClearRange,D,2,E,202");

int a = 123;
Serial.print("CELL,SET,E2,");
Serial.println(a);

Serial.println("CELL,GET,E2");
int b = Serial.parseInt();

Serial.print("CELL,SET,D2,");
Serial.println(b);

String c = "TEST";
Serial.print("CELL,SET,E3,");
Serial.println(c);

Serial.println("CELL,GET,E3");
String d = Serial.readString();

Serial.print("CELL,SET,D3,");
Serial.println(d);

Than I inserted 'while (!Serial.available()){}' to see if my Arduino receives data from the EXCEL by the execution of 'Serial.println("CELL,GET,E2");' command. In this case, the program stays at 'while (!Serial.available()){}' command and never goes beyond.

Serial.println("ClearRange,D,2,E,202");

int a = 123;
Serial.print("CELL,SET,E2,");
Serial.println(a);

Serial.println("CELL,GET,E2");
while (!Serial.available()){} // << inserted
int b = Serial.parseInt();

Serial.print("CELL,SET,D2,");
Serial.println(b);

String c = "TEST";
Serial.print("CELL,SET,E3,");
Serial.println(c);

Serial.println("CELL,GET,E3");
String d = Serial.readString();

Serial.print("CELL,SET,D3,");
Serial.println(d);

I am a newbie in terms of programming. I wonder if there exist some timing issues. Does anyone have any clue?

Sam

[NetDevil]

Hi jl1cny,

might be I found the problem. I was able to recreate the same issue when using baud rates greater then 19200. Might be that it is just to fast for my PC / your PC and or Excel or the Arduino.

When using baud rate of 9600 or 19200 all my get / set commands were executed correctly.

I attached a test sketch and a special Excel sheet for you to try.

The sketch has 4 test cases:

• read int from B4 to B8 and show in DirectDebug window
• read string from C4 to C8 and show in DirectDebug window
• read string from E4 to E8, store it, put a random string in E4 to E8 and put old value in D4 to D8 (read / change / switch)
• read int from G4 to G8, increase by one, put result in G4 to G8 and put old value in F4 to F8 (read / increase / switch)

All is running well with baud up to 19200.

Please just give it try and in case it is running well try to reduce your baud rate.

And one more thing, when posting code please use the code tags for better readability.

[ code]put code here[/ code]

and remove blanks'

PLX-DAQ-TestingSketch.zip (139 KB)

[NetDevil]

Updates Updates Updates

---

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

---

What's new in "version 2.8" aka Change log:

• fixed an issue with the LABEL command. Columns that should labeled either TIME, TIMER or DATE where translated as well thus the column was not labeled with e.g., DATE but accidentally resolved to current system date (e.g., 21.02.2017)
• fixed in issue with 32 bit Office versions and sleep function. Should be working on 64 bit and 32 bit versions again. Issue was reported by ankoo here
• removed two deprecated commands from PLX DAQ v1 (RESET and CMD?) as they were of no use anymore
• realigned source code for better readability, reused functions more often to reduce redundancy, commented out old checkbox calls from PLX DAQ v1 that are deprecated within commands
• corrected a mistake in the comments of the default sketch (column naming)

Backlog for next version(s):

• find a solution for Excel crashing when moving the window around while logging. Priority: low ; Workaround: don't move window while logging ; Status: clueless...
• solve get cell / set cell mix up reported by jl1cny here. Priority: high ; Workaround: none(!) ; Status: in contact with Sam directly via email to identify issue. Best guess is an issue in Arduino code where different variables point to the same addresses in RAM

Image-Link: http://www.freebie-base.de/Pics/PLX_DAQ_v2.8.png
(hosted on my server, no traffic hijack)

What's new in "version 2.7" aka Change log:

• Added a new command: ClearRange that allows for a range to be cleared in the sheet.
  Syntax is Serial.println("ClearRange,StartColumn,StartRow,EndColumn,EndRow"); ==> e.g., Serial.println("ClearRange,B,2,D,50");
• fixed a bug when closing the form while still logging. The macro was not paused correctly but will do so now

What's new in "version 2.6" aka Change log:

• Fixed the reset timer button (there was a useless message box implemented somehow)
• Formatted the timer to always have 6 trailing digits
• removed the old fashioned limit to 27 columns - now supports the thousands of columns that Excel supports (although it is getting pretty slow with too many columns)
• Set the columns all to be aligned centrally on default and column captions to be written in bold by default
• and well yeah - added the warning remark not to play around too much with the window during logging

What's new in "version 2.5" aka Change log:

• Added a "Pause logging" / "Resume logging" button that can (well no surprise) stop the logging of the data without disconnecting the Arduino. The Button is enabled when connected

• Removed the old 4 checkboxes as the functions are useless without Stamp nowadays and replaced with 3 custom checkboxes. As with old PLX DAQ v1 these checkboxes can be controlled by Arduino code: change text, check/uncheck box, read status of boxed (if checked or not). Codes changed from "DOWNLOAD" / "STORED" / "USER1" to CUSTOMBOX1 / CUSTOMBOX2 / CUSTOMBOX3. "USER2" was removed completely.

• Moved "Reset on Connect" around a bit for better UI layout

• Re-implemented the code for "Reset Timer" button. I don't know why I removed that anyways in version 2.1 ....

• I added a new example sketch that demonstrates the new functions and how one can use them

• I also rework the example codes in the custom dev points for not crashing Excel anymore - hopefully

• Added new functions to call in Excel by Arduino:

• Beep : makes a simple beep

• Pauselogging : stops printing logged data to the Excel sheet

• Resumelogging: continues pasting data again

• Stoplogging : disconnects the Arduino

• Saveworkbook : simply saves the workbook

• SaveworkbookAs,Filename : saves the workbook as a new copy in the same folder by the name Filename.xlsm

• ForcequitExcel: forces Excel to close. Note: the workbook will not be saved by this!

What's new in "version 2.4" aka Change log:

• Fixed a UI problem with Office 365
• Implemented 2 "custom dev points" ("new line was read" and "new data row recognized") which get called by the system automatically and where custom code can be pasted and used (example included in code)

What's new in "version 2.3" aka Change log:

• Port and baud rate not drop down box anymore but free text fields
• Port number bug fixed thus ports > 10 can be used (max set to 256 as of modern Windows OS limit)

What's new in "version 2.2" aka Change log:

• Enhanced 64 bit support (even better stability now)
• Added a dropdown box to select with sheet to post to (got rid of the radio buttons)
• Minor adjustment for faster startup of logging

What's new in "version 2.1" aka Change log:

• --- version never released ---
• --- it was more of an "internal development version"

What's new in "version 2":

• Support for both Office versions 64 bit as well as Office 32 bit
• No more installation needed! All within the workbook
• I got rid of the selmaDAQ_Ver2.ocx and use API calls now
• Fully compatible to all previous PLX-DAQ commands in your code!
• Got rid of some old stuff like "Max row size of 65000" (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
• Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
• Setting for selecting where to post data (first most left sheet or currently active sheet)
• Disabled the control boxes as Stamp object is no more in use

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

PLX-DAQ-v2-DefaultSketch.ino (2.2 KB)

PLX-DAQ-v2.8.zip (139 KB)

[anon17055972]

Hi NetDevil

Many thanks for the ClearRange command. This enables an easy workaround for the inability to read from other sheets. Just set a cell in Simple Data (that is not cleared) equal to the cell in the other sheet you want to read from.

SASv

P.S. In your version 2.8 update you state in Backlog for next version(s):
"solve get cell / set cell mix up reported by jl1cny here. Priority: high ; Workaround: none(!)"
But for those who can afford lower baud rates you already posted a workaround, it is to lower the baud rate. I checked it and it works. As I have occasional issues with 9600 baud, I will be using 4800.

[NetDevil]

Hi SASv,
thanks for your feedback. Let's see:

SASv:
This enables an easy workaround for the inability to read from other sheets. Just set a cell in Simple Data (that is not cleared) equal to the cell in the other sheet you want to read from.

Interesting issue. You are right, you can only read values from the current sheet and with having had only CLEARSHEET your reference cell was deleted as well. I will add a feature within the next version to read data from other sheets (by name) as well. Right now I am thinking of something like:

// ## NOTE: function not yet implemented in PLX DAQ v2
Serial.println("CELL,GET,FROMSHEET,MyConfigSheet,C,5");

SASv:
P.S. In your version 2.8 update you state in Backlog for next version(s):
"solve get cell / set cell mix up reported by jl1cny here. Priority: high ; Workaround: none(!)"
But for those who can afford lower baud rates you already posted a workaround, it is to lower the baud rate. I checked it and it works. As I have occasional issues with 9600 baud, I will be using 4800.

Good to know it is working well for you. I still need to get to the bottom of the issue and was hoping the workaround would suite for more people. Could you post me the code you are having issue with at 9600 baud? Are you using more then 1 variable to store data?

[anon17055972]

Hi NetDevil

Apologies, I should have specified that I had occasional issues at 9600 baud with version 2.3. Version 2.8 has no issues at 9600 baud, and I will be switching to version 2.8.

A "CELL,GET,FROMSHEET,MyConfigSheet,C,5" command would be great.

Many thanks!

[NetDevil]

Hey there, I added the command to the programm and did some more research on the issues with the window crash and cell mix up. Unfortunately there is no update on those issues yet. Still pretty mysterious ... Nevertheless I'll reduce the priority as baud rates of around 9600 seem to work without any problems.

---

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

---

What's new in "version 2.9" aka Change log:

• Extended the CELL,GET command to read cells from other sheets as well.
  Syntax is Serial.println("CELL,GET,FROMSHEET,SheetName,Column,Row"); ==> e.g., Serial.println("CELL,GET,FROMSHEET,Simple Data,E,4");

• Updated the default sketch to include the new command

Backlog for next version(s):

• find a solution for Excel crashing when moving the window around while logging. Priority: low ; Workaround: don't move window while logging ; Status: clueless...
• solve get cell / set cell mix up reported by jl1cny here. Priority: medium; Workaround: use baud rates smaller 25.000; Status: in contact with Sam directly via email to identify issue. Best guess is an issue in Arduino code with Serial.ParseInt not getting values out of buffer correctly
• implement new feature CLEARDATA. Command CLEARSHEET does not clear labels. Thus CLEARDATA should clear all data starting cell A2 with all columns and all rows, CLEARSHEET should start at cell A1 with all columns and rows (thus including labels in row 1).

Guideline to migrate from old version to new one:

• if you want to use the new version of PLX DAQ v2 but want to keep all your configured sheets in old Excel version of PLX DAQ try the following steps to copy all sheets, references and formulas easily to the new version:
• Download new PLX DAQ Excel and open, open your Excel as well.
• In your old Excel select first sheet (e.g., "Simple Data"), then hold shift key and select last sheet, right click firest sheet and select "Move or Copy"
• select new PLX DAQ Excel in the dropdown, select "move to end", select "Create a copy" and press OK.
• It should copy all sheets to the new version. Might be Excel will rename "Simple Data" to "Simple Data (2)" because it is already in new version of PLX DAQ default workbook but you can easily remove the new sheet and rename yours back to "Simple Data"

Image-Link: http://www.freebie-base.de/Pics/PLX_DAQ_v2.9.png
(hosted on my server, no traffic hijack)

What's new in "version 2.8" aka Change log:

• fixed an issue with the LABEL command. Columns that should labeled either TIME, TIMER or DATE where translated as well thus the column was not labeled with e.g., DATE but accidentally resolved to current system date (e.g., 21.02.2017)
• fixed in issue with 32 bit Office versions and sleep function. Should be working on 64 bit and 32 bit versions again. Issue was reported by ankoo here
• removed two deprecated commands from PLX DAQ v1 (RESET and CMD?) as they were of no use anymore
• realigned source code for better readability, reused functions more often to reduce redundancy, commented out old checkbox calls from PLX DAQ v1 that are deprecated within commands
• corrected a mistake in the comments of the default sketch (column naming)

What's new in "version 2.7" aka Change log:

• Added a new command: ClearRange that allows for a range to be cleared in the sheet.
  Syntax is Serial.println("ClearRange,StartColumn,StartRow,EndColumn,EndRow"); ==> e.g., Serial.println("ClearRange,B,2,D,50");
• fixed a bug when closing the form while still logging. The macro was not paused correctly but will do so now

What's new in "version 2.6" aka Change log:

• Fixed the reset timer button (there was a useless message box implemented somehow)
• Formatted the timer to always have 6 trailing digits
• removed the old fashioned limit to 27 columns - now supports the thousands of columns that Excel supports (although it is getting pretty slow with too many columns)
• Set the columns all to be aligned centrally on default and column captions to be written in bold by default
• and well yeah - added the warning remark not to play around too much with the window during logging

What's new in "version 2.5" aka Change log:

• Added a "Pause logging" / "Resume logging" button that can (well no surprise) stop the logging of the data without disconnecting the Arduino. The Button is enabled when connected

• Removed the old 4 checkboxes as the functions are useless without Stamp nowadays and replaced with 3 custom checkboxes. As with old PLX DAQ v1 these checkboxes can be controlled by Arduino code: change text, check/uncheck box, read status of boxed (if checked or not). Codes changed from "DOWNLOAD" / "STORED" / "USER1" to CUSTOMBOX1 / CUSTOMBOX2 / CUSTOMBOX3. "USER2" was removed completely.

• Moved "Reset on Connect" around a bit for better UI layout

• Re-implemented the code for "Reset Timer" button. I don't know why I removed that anyways in version 2.1 ....

• I added a new example sketch that demonstrates the new functions and how one can use them

• I also rework the example codes in the custom dev points for not crashing Excel anymore - hopefully

• Added new functions to call in Excel by Arduino:

• Beep : makes a simple beep

• Pauselogging : stops printing logged data to the Excel sheet

• Resumelogging: continues pasting data again

• Stoplogging : disconnects the Arduino

• Saveworkbook : simply saves the workbook

• SaveworkbookAs,Filename : saves the workbook as a new copy in the same folder by the name Filename.xlsm

• ForcequitExcel: forces Excel to close. Note: the workbook will not be saved by this!

What's new in "version 2.4" aka Change log:

• Fixed a UI problem with Office 365
• Implemented 2 "custom dev points" ("new line was read" and "new data row recognized") which get called by the system automatically and where custom code can be pasted and used (example included in code)

What's new in "version 2.3" aka Change log:

• Port and baud rate not drop down box anymore but free text fields
• Port number bug fixed thus ports > 10 can be used (max set to 256 as of modern Windows OS limit)

What's new in "version 2.2" aka Change log:

• Enhanced 64 bit support (even better stability now)
• Added a dropdown box to select with sheet to post to (got rid of the radio buttons)
• Minor adjustment for faster startup of logging

What's new in "version 2.1" aka Change log:

• --- version never released ---
• --- it was more of an "internal development version"

What's new in "version 2":

• Support for both Office versions 64 bit as well as Office 32 bit
• No more installation needed! All within the workbook
• I got rid of the selmaDAQ_Ver2.ocx and use API calls now
• Fully compatible to all previous PLX-DAQ commands in your code!
• Got rid of some old stuff like "Max row size of 65000" (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
• Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
• Setting for selecting where to post data (first most left sheet or currently active sheet)
• Disabled the control boxes as Stamp object is no more in use

=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================

PLX-DAQ-v2.9.zip (144 KB)

PLX-DAQ-v2-DefaultSketch.ino (2.57 KB)

[anon17055972]

Possible Workaround to GET/SET Issues for High Baud Rates

I found that the GET, SET, and the new Serial.println("CELL,GET,FROMSHEET,SheetName,Column,Row");
commands can work well even at high baud rates if a small delay is added after serial interactions.
The following test code was tested in three computers (two Windows 7 and one Windows 10):

// First you must have NetDevil's Excel file PLX-DAQ-v2.9.xlsm open and
// PLX-DAQ-v2.9 connected at the appropriate port with the desired baud rate.
// Download it from
// PLX-DAQ version 2 - now with 64 bit support! (and further new features) - #59 by NetDevil - Interfacing w/ Software on the Computer - Arduino Forum
// Enter a numerical value in cell J3 of sheet Simple Data
// Enter a numerical value in cell F6 of sheet Further sheet
// Code for a second serial port (SoftSerial) has been added so that one serial port can
// be dedicated for output to Excel using NetDevil's PLX-DAQ-v2.9 and the
// other serial port to the Arduino monitor
// A CP2102 cable does the job well for connecting the Arduino soft serial
// pins to a 2nd computer USB.

//PRELIMINARIES
#include <SoftwareSerial.h> // include the software serial port library

//Soft serial pins
#define rxPin 8 //connect to green wire of CP2102 or to orange wire of FTDI
#define txPin 7 //connect to white wire of CP2102 or to yellow wire of FTDI

// set up a new serial port
SoftwareSerial excelSerial = SoftwareSerial(rxPin, txPin);

unsigned long baudr = 38400; //Do not forget to change the baud rate in PLX-DAQ and in the serial monitor
byte tdelay = 3;

void setup(void) {
// define pin modes for tx, rx:
pinMode(rxPin, INPUT);
pinMode(txPin, OUTPUT);
// set baud rates for both ports
excelSerial.begin(baudr);
delay(tdelay);
Serial.begin(baudr);
delay(tdelay); //A workaround to the GET/SET issues is to put a small delay after serial interaction commands
// testing SET
excelSerial.println("ClearRange,A,1,F,100");
delay(tdelay);
float Ans = 42;
Serial.println(Ans);
delay(tdelay);
excelSerial.print("CELL,SET,D3,");
delay(tdelay);
excelSerial.println(Ans);
delay(tdelay);
// testing GET
Serial.print(F("Test print is "));
delay(tdelay); // To be safe I have added delays even where they are probably not needed
excelSerial.println("CELL,GET,J3");
delay(tdelay);
float NotAns = excelSerial.parseFloat();
delay(tdelay);
Serial.println(NotAns);
delay(tdelay);
// testing GET FROMSHEET (thanks NetDevil)
excelSerial.println("CELL,GET,FROMSHEET,Further sheet,F,6");
delay(tdelay);
float AnsAns = excelSerial.parseFloat();
delay(tdelay);
Serial.println(AnsAns);
delay(tdelay);
Serial.println("DONE");
}

void loop(void) {;}

//End of code

Update:
Further testing using a Windows 10 computer showed that this workaround is not effective 100% of the time at 115200 baud.
At 115200 baud & tdelay = 3, all printouts were correct about 85% of the time (34/40 trials).
At 115200 baud & tdelay = 10, all printouts were correct about 90% of the time (18/20 trials).
At 38400 baud & tdelay =10, 20 out of 20 trials were completely successful.
At 38400 baud & tdelay =3, 30 out of 30 trials were completely successful.

Previous Caution Removed:
I had previously cautioned that an inexpensive CP2102 cable from China failed to perform. I was incorrect, it was a loose wire.