Hi,
I have a pricing spreadsheet which enables you to choose a Month/Year on which to base the pricing (e.g. April 2015/June 2015 etc.).
I have multiple HTML pages on a web server (e.g. Pricing-Apr15.html, Pricing-June.html).
I want the user to pull down a month (e.g. April/May/June etc.) and then for the pricing sheet to pull the pricing data from the relevent HTML file on the webserver.
I don't see any way to make the Connection String dynamic in the Connection Properties (see screenshot, attached).
![excelscreenshot.png]()
Help!
Thanks :)
http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/statebankindia/SBI
http://www.moneycontrol.com/india/stockpricequote/banks-public-sector/bankofbaroda/BOB
The only changing part is after banks-public-sector..rest of the link is constant..let me know is my assumptions correct in this case??
Saurabh...