Solved

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

Posted on 2013-05-13
6
326 Views
Last Modified: 2013-05-13
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.
0
Comment
Question by:f19l
  • 3
  • 3
6 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
It may depend on the site. Have you tried using a Web query (Data tab, From Web in Excel 2007 or later)?
0
 

Author Comment

by:f19l
Comment Utility
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.
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
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.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:f19l
Comment Utility
Yes, I do know the URL. Do you know the code that I will need?
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
Comment Utility
I would start by trying:
Workbooks.Open "URL_here"

Open in new window


If that doesn't work then you'll probably need to automate the download.
0
 

Author Comment

by:f19l
Comment Utility
As simple as that! It works.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now