Hi Friends,
I am trying to export some data from web using MACRO, However I am facing some challanges such as
. Cant save login Credential, Need to login everytime I run the MACRO,
. And result I get in multiple excel tabs, rather I need them in one tab one after the other
Instance: If I have exce; sheet Column A with CUSIP's and if I enter one in that particular web site I get
Effective Date, Event Type, Description, CUSIP and Tracking in a table, And for the next CUSIP from Column A I get the same info however I get it in new tab, rather I am looikng in the same sheet follwoed by the first one.
Prior to that I need to mannually type in login credentials every time in Excel>Data>From Web> New Web Query (Pop-Up) and it would be great if I could save the credential in the code itself.
not sure If i could share the login credentials, but please help me on this, It very important
I have attached copy of screenshots and a Sample excel file too.IDC.docxInteractive Data.xlsm
Bookmarks