Link to home
Start Free TrialLog in
Avatar of Codestone
Codestone

asked on

Excel: Getting data from a dynamic URL

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).
User generated image
Help!

Thanks :)
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Quick question if i understand correctly what you are trying to say that in your web sever the entire link remains constant the only change part is the months..Like in the below example of links...

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...
This usually requires VBA code. The connection string URL does not allow for variable parts.
Avatar of Codestone
Codestone

ASKER

Hi Saurabh, yes your assumption is correct
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect - thanks :)