Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 3rd, 2009, 10:41 PM
Authorized User
 
Join Date: May 2009
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Link an excel table to external (web) data

Is there a way to link an excel table to an external data source?

The is a set of government data that is published periodically that we use. Ideally, we would to link a spreadsheet to that data and have it refresh automatically, or to refresh when we ask it to. Either way would be fine and much nicer that going through the whole open the web page and go through the copy and paste routine.

The external data source is completely consistent in their layout.
 
Old September 3rd, 2009, 11:52 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

This is very much possible using Web Queries

In Excel 2007 you can do this from Data-->From Web-->Type the website Address in the dialog-->Click Go-->Get the table you want

In Excel 2003 you can do this from Data-->Get External Data-->From Web-->Type the website Address in the dialog-->Click Go-->Get the table you want

The website table will be loaded in the Excel sheet. You can refresh this table manually or you can write some small code to refresh the table at selected intervals

This particular table is called as 'QueryTable' in VBA.

Happy loading data. Do not hesitate to post here if you face any issues

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access external link to Excel in Sharepoint wortinguk Access 1 October 20th, 2006 10:32 AM
Link Problems with"unresolved external symbols" ConstantineAugustus Visual C++ 2 November 22nd, 2005 06:34 AM
.asp request from Excel (Import External Data) chs245 Classic ASP Basics 1 October 6th, 2003 04:24 PM
Relative Link to External Style Sheet arduk ASP.NET 1.0 and 1.1 Basics 1 June 18th, 2003 09:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.