[dba-SQLServer] How to problematically (or by other automation) control an ActiveX control in IE

Francisco Tapia fhtapia at gmail.com
Wed Dec 14 12:58:06 CST 2011

First, Happy belated birthday Rocky!

  Does the customer have control of the online database?  if so the
automation could just be made at the Excel spreadsheet to push out to the
online db.  right?

if it's a 3rd party database, then automation might just be key, take a
look at http://www.autohotkey.com/  we use it here to help control our
touchscreen kiosk.

http://bit.ly/sqlthis   | Tsql and More...

On Mon, Dec 12, 2011 at 14:54, Mark Breen <marklbreen at gmail.com> wrote:

> Hello All,
> I arrived into a customer today with the intention of preparing for a
> project to automate a process for placing orders in an online database.
> The process today is that the user sits for four hours and copy and pastes
> from Excel into a browser.  I was hoping to use Selenium to automate that.
> However, I was disappointed to note that the website is actually an ActiveX
> control running in IE.
> That leaves me with options such as
> a) using other macro software, attempt to automate the process
> b) find out how to programatically manipulate an ActiveX
> c) some other option not thought of yet.
> I am asking the list whether you have any advice to give?  If this ActiveX
> has been installed on the PC and runs well, how difficult would it be to
> execute all the functionality it offers?  I may have no documentation.
> Does my question even make sense?
> Your advice, as always, is appreciated.
> thanks
> Mark
> PS, Happy Birthday to Rocky
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

More information about the dba-SQLServer mailing list