html - How to handle authentication dialog while accessing the webpage from Excel macro -
i trying access 1 webpage , retrieve required data excel. using excel macro cause. webpage accessing asking username , password in form of browser dialog below:
this not html page not able locate username , password texts , provide values.
i tried give value directly using sendkeys
ie.navigate cells(rownum, 3) sendkeys "admin" sendkeys "{tab}" sendkeys "admin" sendkeys "{enter}
it working fine if dialog appears. webpage ask credentials @ first instance. rest of time, webpage getting opened automatically without credentials. now, in need of way check if dialog box visible. me in resolving this?
i tried appactivate
appactivate(iexplore)
but doesn't seem working.
Comments
Post a Comment