How to get website results in to excel

[rg_nath]

Hi,

I have a problem,

i want to get the data from one https:// web site (internet) by running the multiple inputs which are input feed to that website (in the website have only one input box) via excel cell. in the web site, after giving one input data in to text box,and then after click on the 'go' button, the result will be shown in tablular format. i want this reslut in excel by giving the multiple inputs execute at a time. For Ex:

In the web site we have:
___
Login Name : | Text box | |go|
---
Result Table:
----------------------------------------
|Name | address | city | designation |
----------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD |
----------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG |
----------------------------------------

In Excel:

----------------------------------------------
|A |B | C |D
----------------------------------------------
|AAAA | | |
----------------------------------------------
|BBBB | | |
----------------------------------------------
|CCCC | | |
----------------------------------------------

By giving the above input via excel and it will run the website and get the values and pull the reslut data in to another sheet or same sheet in some other cell.like below(another sheet)

------------------------------------------------
|A |B | C |D
------------------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD
------------------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG
------------------------------------------------
|BBBB |BBBBB |CCCC | DDDDDD
------------------------------------------------
|BBBB |EEEEE |FFFF | GGGGGG
------------------------------------------------
|CCCC |BBBBB |CCCC | DDDDDD
------------------------------------------------
|CCCC |EEEEE |FFFF | GGGGGG
------------------------------------------------

Please help me to get this... Thanks in advance.

Regards,
Nath.

[shasur]

You can try QueryTables if the searchtext is part of the WebAddress.

[dominicb]

Good morning rg_nath

...and welcome to the forum!!

i want to get the data from one https:// web site (internet) by running the multiple inputs which are input feed to that website (in the website have only one input box) via excel cell. in the web site, after giving one input data in to text box,and then after click on the 'go' button, the result will be shown in tablular format. i want this reslut in excel by giving the multiple inputs execute at a time.

To import data from a web page to Excel go to Date > Import External Data > New Web Query.

Put the http address in the box at the top and click "Go". Follow the prompts from there.

Just be aware that the data might not come across exactly as you need it and just be prepared to do some alterations with your formatting.

HTH

DominicB

[rg_nath]

Hi Shasur,

Thanks for your quick reply !!....
No, searchtext is not the part of the WebAddress. if possible can you please explan me what about "QueryTables ". actually my site is build in asp. after giving the site name in the address bar it shows the main page (before open the page, it is popup msg as Security alert). after when i entered the login again it is popup msg as Security alert. and then after cliking the go button also it pops security alert msg. but the page address is showing same even i click on go button also... and after getting the results also. pleas let me know is there any macro to get the securied data from HTTPS://xxxx.xx.xx.asp sites.

[rg_nath]

HiDominicB,

Thanks !!...

Actually i tried that what you explained. in the excel sheet it copies only 'Loginid' string and it not able to get the reslut strings and pop ups a message to me like "This web query returnd no data. To modify the query,click OK,click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar." When i going back to Edit Query, it opens a site with 'Loginid' page (with out results, first page). means it not able to retrive the data from the result table in the site.