HELP: Web Query Vs Need to Log in

[Clinton M James]

Hi All,

I have vba code that downloads various files from a site but prior to
running it i need to launch web query in excel and log in through it - the
thing is I want excel to do the logging in for me without my having to go
into web query and manually doing it first.

Does anybody know how I can get excel to make the connection and send my
username and password?

Help is appreciated and thank you in advance

Regards,
Clint

 

[Madiya]

Hi All,

I have vba code that downloads various files from a site but prior to
running it i need to launch web query in excel and log in through it - the
thing is I want excel to do the logging in for me without my having to go
into web query and manually doing it first.

Does anybody know how I can get excel to make the connection and send my
username and password?

Help is appreciated and thank you in advance

Regards,
Clint

Yes. It can be done.
Look into the source code of the web page, locate the elements there,
assign the values and you are done.

Pl post your code for more help.

Regards,
Madiya

 

[Madiya]

Hi All,

I have vba code that downloads various files from a site but prior to
running it i need to launch web query in excel and log in through it - the
thing is I want excel to do the logging in for me without my having to go
into web query and manually doing it first.

Does anybody know how I can get excel to make the connection and send my
username and password?

Help is appreciated and thank you in advance

Regards,
Clint

Yes. It can be done.
Look into the source code of the web page, locate the elements there,
assign the values and you are done.

Pl post your code for more help.

Regards,
Madiya