<div>
It may depend on the site. Have you tried using a Web query (Data tab, From Web in Excel 2007 or later)?
</div>


It may depend on the site. Have you tried using a Web query (Data tab, From Web in Excel 2007 or later)?

<div>
My knowledge is very basic in this regard. You will need to take me step-by-step through this process. Actually, I have just realized this is going to be more involved than I first thought; I go to the website, click on a link to a spreadsheet containing the required data, save it and then open it up.
</div>


My knowledge is very basic in this regard. You will need to take me step-by-step through this process. Actually, I have just realized this is going to be more involved than I first thought; I go to the website, click on a link to a spreadsheet containing the required data, save it and then open it up.

<div>
I don't think you will be able to create a direct link then. You might be able to use code to get the workbook and manipulate it as long as you know the direct link (URL) to the workbook.
</div>


I don't think you will be able to create a direct link then. You might be able to use code to get the workbook and manipulate it as long as you know the direct link (URL) to the workbook.

Yes, I do know the URL. Do you know the code that I will need?

<div>
As simple as that! It works.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have an excel spreadsheet that I need to update every day. I have now been told that one of the sources of information I will need is a financial website. I would like to know if it is possible to create a direct link from this website to my spreadsheet so that when I open up the excel file it will auotmatically update these links?<br />
<br />
Thanks.
</div>
</div>


Hello,

I have an excel spreadsheet that I need to update every day. I have now been told that one of the sources of information I will need is a financial website. I would like to know if it is possible to create a direct link from this website to my spreadsheet so that when I open up the excel file it will auotmatically update these links?

Thanks.

How do I pull in data from a website into an excel spreadsheet?

Web browsers are applications used primarily to display documents, files and media from the Internet, identified by a Uniform Resource Identifier (URI) that can be a page, image, video or other file. Some browsers require the use of add-ons or extensions to safely render the information they receive; others have systems built into them to perform the same functions.

Web Browsers

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.