+ Reply to Thread
Results 1 to 2 of 2

How to import a section of a webpage without importing the entire page

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Question How to import a section of a webpage without importing the entire page

    I want to import currency rate information, specifically this page for my accounts. I am able to use the Data -> From Web function in Excel however it picks up the entire webpage as an importable 'table' without giving me other options.

    This is fine and it functions the way I want to an extent as I'm able to use =Sheet2!C74 to import the cell containing the current rate to my accounting sheet. However due to the rest of the webpage being updated every time I hit 'Refresh', the spreadsheet is becoming quite slow to load as I'm loading in more currencies (i.e. BCH rates) to other worksheets.

    Is there any way to lessen the amount of data that excel imports from the website? I can't see that there's a way to manually highlight a table to import through the Data -> From Web function, and deleting the other unneeded cells in the worksheet just results in them being repopulated upon 'Refresh'.

  2. #2
    Registered User
    Join Date
    08-23-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Re: How to import a section of a webpage without importing the entire page

    .....................

+ 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. Copy entire page from webpage and import into excel spreadsheet
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2016, 01:06 PM
  2. [SOLVED] Data Import Only importing small amount of web page
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-30-2016, 03:16 PM
  3. [SOLVED] Having difficultly moving a section from page 3 to page 2 in a word document form
    By UNAB in forum Word Formatting & General
    Replies: 2
    Last Post: 03-25-2013, 07:52 AM
  4. Excel Import Data not importing entire data set
    By gravine in forum Excel General
    Replies: 1
    Last Post: 02-01-2012, 02:33 PM
  5. Importing data from a webpage. I need an expert!
    By jimatdks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2012, 09:33 PM
  6. query tables in VB not importing entire web page
    By hariimmadi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2011, 12:12 AM
  7. Importing from Webpage
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2008, 12:42 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