Hello all,
I rarely post questions as I will search it out for hours. I've spent over 2 days reading every support group and no-one has seem to provide a usable response. If you are a fellow expert out there here's a challenge. USE CASE: We are running Web Queries daily to load dynamic data daily. The data we are extracting from our partner requires a successful login. The site works, there are not internet issues. Yes there are several other solutions that might be better and using Excel for this not ideal, but please trust me that for certain reasons a few feature's of Excels Web Query make this method preferred. We are dynamically building Web Queries via VBA. The queries load, return the data and everything works as designed, except. PROBLEMS: Excel does not not access (from what we can find) session or login information for any other browser/session unless it was initiated through Excel. Therefore, everyday we must create a new static Web Query, load the login page (example: https://www.mysite.com/login), enter our credentials, hit login and then cancel out of the Web Query. Then we may proceed to run the VBA Web Query successfully as Excel has access to the login session. QUESTIONS: Is there any way to pass to Excel/VBA login session info from a browser outside of Excel? If not, is there a way to dynamically, via VBA, to create a login session through WEB QUERY. Please don't send me code (like 100's of other sites) showing how to initiate an IE control and pass UserName/Password to a login page as I'm quite proficient. The issue is Excel's Web Query - Web Query must create the login session in order for the login session to be accessed/recognized. Has anyone created a workaround to this? Normally I would post code but it's not relevant to this question. If I do not FIRST go to Excel/Data/Connections/Properties/Edit and load a login page and signin, it doesn't matter what the code does via VBA as Excel will not accept a login session from a VBA IE control. Any help/insight/workaround/solutions would be much appreciated. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
