I have some questions. As stated in the title, I need to be able to add information from 3 sources (2 spreadsheets from the same workbook, and 1 from the browser) into one row on a pre-made excel workbook, dynamically.
I started off by creating the variables needed by reading specific cells and one range in the first workbook (it has 2 spreadsheets). Then I assigned values to the other variables that will be gathered later from the browser and a current date ToString.
Next I was able to write those variables into a mock spreadsheet, in the order needed.
First question is: Can I use the Assign Multiple function to create a “data table row” and then use Append Range to write that info into the next available blank row?
Second Question: If not, then how else can I write the 7 variables into one row dynamically?
The columns are fixed with named headers.
Please let me know how to do this as a google search turned up nothing specifically helpful.
All the variables being input have values established. The only weird one is the GenericValue, I couldn’t get it to work as an Int32 type even though it is a 13 digits number. Does the type of variable matter when adding them in to the ArrayRow?
The variable labeled as “RDOprocessed” is supposed to be the output data table from Add Data Row.