Paste web page into workbook

[skyblues]

Hi, I have some code that opens a web page and enters two input boxes then submits the entries and a value is returned to the web page. I wanted to return the value to a work sheet but my knowledge is limited so I thought I'd copy and paste the web page into a worksheet instead but it doesn't appear to work. Nothing is pasted. Any help would be greatly appreciated. Thanks in advance.

[mrice]

Try using

Please Login or Register  to view this content.

to generate an array of indvidual lines from the HTML which you can then pick from to get the desired value.

[skyblues]

Thanks for the reply mrice. I'm still struggling with this. I've updated the original attached file. The data that is being pasted doesn't seem to be from the current web page it seems to data from when the input boxes have been filled in and not submitted. On the excel sheet you can see lines 28 and 31 have the values filled in. If you look at the page source of the IE window that is open these values aren't filled and the result "Predicted TI is 13.331352260039" is shown in the source but not the data pasted in Excel.

[Leith Ross]

Hello skyblues,

Working with Internet Explorer through VBA is a bit tricky. Since Internet Explorer is started asynchronously from VBA, the VBA code runs at its own pace. The trick is to synchronize the VBA code execution with what Internet Explorer is doing. The way to do this is by using a Class Module with events.

The attached workbook uses "A2" and "B2" as the ASI inputs. "C2" is where the calculated web page result is returned. There is a button to run the macro after you input the values.

EDIT: Added error handler


Module1 Macro Code

Please Login or Register  to view this content.

Class Module (IE_Class) Code

Please Login or Register  to view this content.

[skyblues]

Hi Leith,

Thank you very much for solving this and giving me the code I can't thank you enough as I've spent countless hours on trying to solve this with searches.

The help given on this site always surprises me the people who contribute are so knowledgeable and helpful. Thank you again and sorry from straying off the topic.

[skyblues]

Hi Leith,

Could I ask for your help again? I'm trying to put a loop that looks up how many cells are populated in column A and then loop that many times. When I put a loop in I receive the following error: Run Time Error '70' Permission Denied.
Thanks once again

[skyblues]

Apologies I've just looked at my code again and I have made some errors. All working fine now. Thanks