Excel and IE interacting....possible?

jrnyman · Apr 4th, 2002, 03:24 AM

Every evening I have to run a very tedious routine. Using some custom developed software, the routine automatically generates 2 new browser windows displaying files for each of 4 portfolios (= 8 windows). For each portfolio one window is the name of the portfolio and the other is the name followed by SUMMARY.

Generally, I manually copy the URL of the file and open it in Excel. From there, I have to copy certain data to another workbook, but that part i think I can handle. Is it possible to script something that:
(a) recognizes when the IE windows have appeared, and
(b) opens the URL in excel

Thanks in advance.

Tom Schreiner · Apr 4th, 2002, 03:37 AM

Hi
Perhaps you can bypass IE all together and do all of your work in Excel. Has browser capability.
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 03:24 AM	#1
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	Every evening I have to run a very tedious routine. Using some custom developed software, the routine automatically generates 2 new browser windows displaying files for each of 4 portfolios (= 8 windows). For each portfolio one window is the name of the portfolio and the other is the name followed by SUMMARY. Generally, I manually copy the URL of the file and open it in Excel. From there, I have to copy certain data to another workbook, but that part i think I can handle. Is it possible to script something that: (a) recognizes when the IE windows have appeared, and (b) opens the URL in excel Thanks in advance.

Apr 4th, 2002, 03:37 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Perhaps you can bypass IE all together and do all of your work in Excel. Has browser capability. Tom