[Wtr-general] Can I attach to an open Excel session?

[Lou Wilson]

While that's nice and is using stuff I hadn't thought of, it still doesn't answer the question.  Assume now that I ALREADY have the .xls file open.  Remember, it was the file whose macro generated the ruby code that's running.  Of course, the ruby code is calling functions from other static ruby files... but all the variables are put in place by the excel sheet.

Tester fills data out on sheet
Tester hits "Go" button
Excel sheet reads data from the column the tester's in into ruby code
Excel sheet saves and executes ruby code
Watir runs tests on a web page using data it reads from other spreadsheets maintained remotely
Web page saves its results to a SQL Server table
Ruby shuts down
Tester hits "Results" button on Excel sheet
Excel sheet reads results from SQL Server table into spreadsheet.

My idea is to get Ruby/Watir to write those results directly from the table to the OPEN spreadsheet, saving the tester the extra step of hitting the "Results" button.  (Am I coddling the testers too much here?)
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.openqa.org/thread.jspa?threadID=5687&messageID=15915#15915