Getting the data from website which is the result of searched values

Hi,

How to import data from the website which is not on web search, and for accessing the data, one has to enter in the website and than copy paste every time in excel.

If i could not explain the issue, please ask.

Arpit
9623421401

Please help.

Example, you will have to go to your bank website and authenticate log in and than have to know as which cheques will hit today. We just wants to know it directly as soon as I open excel, I must get those details.

Any way out to do so?

Need expert advice.. Please help

Hi Arpit

This is impossible to answer without:

1. The source code of the login Page
2. The source code of the results page

I have tried use of macros to remember the userid and password to be entered But Its not working.

I have my bank's internal website (Intranet) Which is also password protected. I have use id and password but I have to do it every few minutes.

And I have no idea about the source code.

The source code is what the web page is made up of, in Internet Explorer, right click > view source

Okay, that I can do from the bank only AFTER 12 HRS (Its night here 1:00 PM)

And what needs to be done after knowing the source?

PLEASE HELP.. ANY UPDATES

I m now able to view the source code.

Experts pls help.