I have a table in Excel that I am using in Processbook via VBA to access it as a ODBC connection. From that table I get values into a trend with other Pi tags.
I have set a textbox where the user after analyzing the data make some comments that I want to register in the same excel spreadsheet. What i am trying to do is by pressing a button to insert this into excel but would like to do it without opening the application.
is there a way to use the ODBC connection and via INSERT INTO command add a value into excel? Or should I try other options where I store the data rather than excel?
thanks for your input.