I've been kicking an idea around for a while now that would make life so much easier at my office...and was wondering if its even possible. I've got tons of macros I've written in excel that take over a 3270 mainframe interface and key stuff in it like a live person would do. So, for example, the code:
Would put the word "test" into the main frame screen on the 20th row at the 17th column. My question is, is there any way I can do something similar with Internet Explorer? For example, if I have a list of order numbers in excel and need to know who submitted them, can I make the macro open up an Explorer window, navigate to the page our web based tool is on, input the order number into the correct field, click the search button, pull the order up, find the text "order submitter" on the screen, and copy the name that appears next to it back into the excel spreadsheet?
Bookmarks