Excel import data from password protected web site

[pjaj]

I have an Excel 2007 spread sheet into which I want to regularly import some financial data from various web sites. I can do this OK (by setting up connections) for all but one. It is password protected and the data is two screen down from the log in screen.

Is there any way I can do this, or will I have to continue to do it manually - log in, drill down, highlight data and copy / paste special Unicode Text?

Even a time saving partial solution might help.

 

[white605]

What code are you currently using on the sites that you have success at?

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[pjaj]

No code, they are straight forward web queries. As it says in the help :-
"On the Data tab, in the Get External Data group, click From Web" and follow on from there.

It look as if I will have to write a macro or function to log in, which will get me to the customer main page. Then select the particular account link and then select the account details link.

Only then will I have to try to do the equivalent of a web query to extract data from the tables on the page back into the right places in the Excel spreadsheet.

 

[white605]

If you do not have acess to query the tables on the server, you will probably have to
automate login, request page, collect source of page, and parse it out (if it is always the same format)

Examples from "vba automate ie" google search will be helpfull

http://www.mrexcel.com/forum/showthread.php?t=198538

http://www.vbaexpress.com/kb/getarticle.php?kb_id=386

This old world keeps spinning round - It's a wonder tall trees ain't layin' down