| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Web Query Vs Need to Log in
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP: Web Query Vs Need to Log in
On Oct 2, 7:30*pm, "Clinton M James" wrote:
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP: Web Query Vs Need to Log in
On Oct 2, 7:30*pm, "Clinton M James" wrote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
