+ Reply to Thread
Results 1 to 6 of 6

can make a macros copy dats from a web site and enter it into excel?

  1. #1
    Registered User
    Join Date
    01-07-2016
    Location
    manchester
    MS-Off Ver
    2007
    Posts
    77

    can make a macros copy dats from a web site and enter it into excel?

    as the title suggest is it possible?
    what im doing is copying a tables from a website each week which takes me over 20 min to do and was wondering if you can program excel to do it for you..

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: can make a macros copy dats from a web site and enter it into excel?

    Hi,

    Have you looked at the Data Connection functionality?

    What is the web site and which is the data you're interested in?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: can make a macros copy dats from a web site and enter it into excel?

    Hi,

    In newer versions of Excel that allow the Power Query Add-in, this is a common function. See:

    https://bennyaustin.wordpress.com/20...erqueryimport/ or
    https://kzhendev.wordpress.com/2014/...h-power-query/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    01-07-2016
    Location
    manchester
    MS-Off Ver
    2007
    Posts
    77

    Re: can make a macros copy dats from a web site and enter it into excel?

    im only using a WPS excel program is this still posible

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: can make a macros copy dats from a web site and enter it into excel?

    Quote Originally Posted by jono121ukk View Post
    im only using a WPS excel program is this still posible
    That's somewhat difficult to comment on given this is an Excel forum. It's advertised as Excel compatible although what that means in practice I can't say.

    However does the WPS menu structure offer you data connections?

  6. #6
    Registered User
    Join Date
    01-07-2016
    Location
    manchester
    MS-Off Ver
    2007
    Posts
    77

    Re: can make a macros copy dats from a web site and enter it into excel?

    not that i can see..

+ 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. How to make Excel automatically login on a website so it can retrieve data from the site
    By bornacvitanic in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2016, 07:11 PM
  2. How to make Macros cause content to copy/paste to a single location in Excel or Word?
    By energyhill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2014, 01:08 PM
  3. Replies: 3
    Last Post: 11-22-2013, 10:43 AM
  4. How to get data from share point site to excel using macros in 2007?
    By siva1218 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2011, 06:50 AM
  5. how to copy Excel file on to a web site?
    By drace19 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-12-2006, 03:35 PM
  6. [SOLVED] i need to publish an EXCEL workbook with VB macros on my web site
    By nwind in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2006, 06:00 AM
  7. Replies: 1
    Last Post: 08-30-2005, 10:05 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