9/24/2019 Edit Web Query Excel
In addition to using the standard, Select, Copy & Paste process, you can create a Web Query in Excel. The advantage of the Web Query is that when you 'Refresh' it, you now have access to the most current information - without leaving Excel. Web Queries are great for setting up a system to gather the most current Sports Scores, Stock Prices or Exchange Rates. Watch as I demonstrate the process to follow to set this up in Excel. I invite you to visit my online shopping website -to see all of the resources that I offer you.
Join Stack Overflow to learn, share knowledge, and build your career. Changing a URL for Excel Web Query. I have an Excel 2010 spreadsheet that gets information from a data connection. On the properties of the connection is the 'connection string' which is a URL with several parameters that are passed to the server in the query string.
Danny Rocks The Company Rocks.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |