HELP: Web Query Vs Need to Log in

  • Thread starter Clinton M James
  • Start date
C

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
 
M

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top