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

Mark Breen marklbreen at gmail.com
Mon Dec 12 16:54:32 CST 2011


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


More information about the dba-SQLServer mailing list