I try to get access a web page with userid and password to download the data by using web query and EXCEL Macro.
My userid and password won't be recored in my EXCEL Macro.
How could I do this by using Macro and specify userid and password in my macro and automate my process so I could just run EXCEL Macro to get new data.
Any suggestion is greatly appreciated.
My userid and password won't be recored in my EXCEL Macro.
How could I do this by using Macro and specify userid and password in my macro and automate my process so I could just run EXCEL Macro to get new data.
Any suggestion is greatly appreciated.