+ Reply to Thread
Results 1 to 8 of 8

insert data from Web

  1. 02-03-2023, 06:52 PM #1
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Thumbs up insert data from Web

    I Need to Insert data from this web link.

    Data Tab --> New Query --> From Other Sources --> From Web.

    www investing com/equities/united-states

    by default it selects ' Dow Jones Industrial Average ' but I need to get 'United States all stocks'

    (Please use . in Link .. for me I am not allowed to use any web link)
    Last edited by sankeepan; 02-05-2023 at 02:16 PM.
    Reply With QuoteRegister To Reply
  2. 02-04-2023, 03:50 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: insert data from Web

    Hi and welcome
    your profile states you are using XL2003? What you describe was not available at the time I think...
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 02-04-2023, 06:05 AM #3
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Question Re: insert data from Web

    I am using Office 2016
    Reply With QuoteRegister To Reply
  4. 02-04-2023, 06:20 AM #4
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: insert data from Web

    www youtube com/
    watch?v=qfsjSwEytFg

    I create a video about this problem. please watch that video.
    Go to you tube and and Past " watch?v=qfsjSwEytFg " after backslash
    Last edited by sankeepan; 02-04-2023 at 06:23 AM.
    Reply With QuoteRegister To Reply
  5. 02-04-2023, 01:03 PM #5
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: insert data from Web

    External links are notoriously unsafe, so I won't open them. Please explain in words on the board, what you want to do and add a sheet if necessary ( see yellow banner)
    Reply With QuoteRegister To Reply
  6. 02-04-2023, 01:29 PM #6
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: insert data from Web

    go to youtube. I already made a video about that.

    www youtube com/
    watch?v=qfsjSwEytFg

    I create a video about this problem. please watch that video.
    Go to youtube and Past " watch?v=qfsjSwEytFg " after backslash
    Reply With QuoteRegister To Reply
  7. 02-04-2023, 01:36 PM #7
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: insert data from Web

    this is really sad to see. I have a problem but the one who can solve that problem (I think ) He / She afraid of links that I have a problem with that link.

    anyhow thanks for trying.

    these are a few web site for Equity (Free) .
    investing com
    moneycontrol com
    Reply With QuoteRegister To Reply
  8. 02-05-2023, 02:12 PM #8
    sankeepan
    sankeepan is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Sri lanka
    MS-Off Ver
    Excel 2016
    Posts
    8

    Thumbs up Re: insert data from Web

    problem solve
    https //www reddit com/r/excel/comments/10tnc93/need_excel_help_with_from_web_data_insert/
    Thank you Reddit

    Last edited by sankeepan; 02-05-2023 at 02:17 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to insert insert multiple rows between each existing row and past in data
    By Lojinxx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2022, 07:31 AM
  2. Insert blank rows when data changes and calculate how many rows to insert
    By Smartmart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2020, 01:04 PM
  3. [SOLVED] Insert Xnumber (X=A1) of rows between data in a table& copy data from a range to new cells
    By blue_clouds_mountain in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-09-2019, 12:47 PM
  4. Keywords needed- Import data then Macros insert specific data into format
    By jshephe2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2016, 03:20 PM
  5. [SOLVED] Loop through entire sheet, Insert row, copy row data, paste row data, delete row
    By Hyperdude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2012, 01:46 AM
  6. Copy paste data, insert rows, insert data and change . to -
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 01:44 AM
  7. Insert Paste Row - Have A,B,C insert row as well with their data
    By curb in forum Excel General
    Replies: 5
    Last Post: 09-15-2008, 07:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1