+ Reply to Thread
Results 1 to 2 of 2

Web Automation using VBA

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    bangalore
    MS-Off Ver
    MS Office 2010
    Posts
    18

    Web Automation using VBA

    Hi,

    Im new to VBA and would like to get some help from this forum experts. I have 10 digit character in each cell of row A, i need vba to copy each cell contents to a website textbox, retrive information from that and paste in B2

    eg: Cell A2 has 12345, this needs to be copied to website text box and paste the value and click Search button. Then information retrived from search copy that info and paste in B2 and the same should continue for A3 to B3, A4 to B4.

    Iam to able to open IE, copy the first value and get info to b2 but im not sure how to loop the same for all other cells.

    Please Help.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Web Automation using VBA

    Perhaps a loop like ths?

    Please Login or Register  to view this content.
    Last edited by Alf; 03-14-2015 at 10:46 AM.

+ 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. Web Automation
    By shivu98 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-22-2014, 07:53 AM
  2. [SOLVED] Please help with IE automation by VBA
    By vpnvipin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-09-2013, 09:07 AM
  3. Automation help!
    By vicco in forum Excel General
    Replies: 2
    Last Post: 05-16-2008, 05:18 PM
  4. Automation using VBA
    By kingfisher007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2008, 07:29 AM
  5. Automation
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2006, 12:10 PM

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