+ Reply to Thread
Results 1 to 2 of 2

Export Data from Web

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

    Post Export Data from Web

    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

  2. #2
    Forum Contributor
    Join Date
    02-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    187

    Re: Export Data from Web

    This is possible to do, but requires a basic understanding of the code of the website itself.

    You need to identify the exact location (within the code) of the input boxes for login ID /password and then you can pass these values to them.

    I'm afraid it's been a long time since I wrote a programme like this, so can't remember the code off the top of my head: it does exist however, so hopefully that's of some help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combine data from 4 workbooks and then export filtered data to individual files?
    By womanket in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2013, 12:20 PM
  2. I would need a macro to export data from base example workbook to export worbook
    By slato8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 11:21 AM
  3. Excel data (sheet data + charts) export to ppt presentation
    By pntuehut99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2012, 05:55 AM
  4. Replies: 0
    Last Post: 10-14-2010, 08:22 AM
  5. Can I export data into a .csv?
    By FastenerNews in forum Excel General
    Replies: 3
    Last Post: 12-12-2008, 07:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1