+ Reply to Thread
Results 1 to 1 of 1

VBA to send data from excel spreadsheet to a website form and return result to spreadsheet

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    Sheffield, England
    MS-Off Ver
    365
    Posts
    1

    VBA to send data from excel spreadsheet to a website form and return result to spreadsheet

    Hi all

    Can anyone please help with providing code that would allow me to:

    1. Send each of the numbers in column A of the attached spreadsheet (and indeed any amount of numbers included in column A) ie:-

    238554836
    166913834
    205963701
    343475355
    220430231

    to the web address in the attached spreadsheet

    2. Select GB-United Kingdom on the top down menu

    3. Enter each of the numbers in turn into the VAT number box below the above drop down

    4. Return the name of the relevant business back to the spreadsheet in column B next to the original VAT number

    Any help would be much appreciated?

    Thanks
    Dave
    Attached Files Attached Files

+ 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. Extracting Data from Website, Return Result in Table...
    By KomicJ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2015, 08:47 AM
  2. [SOLVED] Website data elements into Excel spreadsheet using VBA
    By wkddj51 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2015, 04:11 PM
  3. data extraction from website to excel spreadsheet
    By wyldjokre69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2012, 07:01 AM
  4. [SOLVED] how to grab data from a website into an excel spreadsheet?
    By flyingdutch06 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-21-2012, 09:27 AM
  5. Outlook send email from data in column from excel spreadsheet
    By benasalisbury in forum Outlook Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2012, 02:24 AM
  6. Extract data from website in an Excel Spreadsheet
    By sh_obaid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2011, 09:05 AM

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