Currently, I have an HTA that is fed with data from an excel spreadsheet. This spreadsheet is generated with an Oracle middleware program called Discoverer. So basically, I have a batch file that runs the Discoverer program at night and exports to an .xls spreadsheet. The HTA then connects to the spreadsheet via ADODB. My question is if it would be possible to remove the step of exporting to an .xls altogether since the Discoverer program has the ability to export to .htm and .xml? My thought is that I run the Discoverer program behind the scenes and simply have the HTA refresh the query with a button click. Is this sort of thing possible? Or better yet, is this sort of thing even practical? Thanks for any suggestions.
HTA Script (Named: Index.hta)
Style Sheet (Named: mystyle.css)
Search Script (Named: search.vbs)
Form Script (Named: forms.vbs)
Batch Script (Named: batch.vbs)
Original Batch Script (Named: batch.bat)