Our company is looking at rolling out an loan application that requires a Credit Bureau report in addition to some other information. What I’d like to do is have an Excel spreadsheet where the interviewer inputs the necessary information, then clicks a macro button that will shell to IE and log on to the secure Equifax site, deliver the company’s credentials, input the variables collected in the Excel spreadsheet by the interviewer, and return the web information into the same spreadsheet for later inclusion in the risk calculation. Has anybody done anything like that before? Is it possible to use an Excel shell to successfully manipulate a secure web site, and return useful information?
Any help that anyone can provide would be much appreciated.
Thanks