stevesansan
New Member
- Joined
- Apr 7, 2010
- Messages
- 5
I am using Excel 2007 on Windows 7 Pro
I have a spreadsheet which is updated from a website. Presently this works from a permanent URL.
I am looking to create a dynamic URL whereby Excel will have two cell which represent the start date and end date, which are to form part of the websire URL. (Presently I have to manually change the URL to change the date ranges).
How do I create the macro and iqy to make the URL dynamic?
Thanks
steve
I have a spreadsheet which is updated from a website. Presently this works from a permanent URL.
I am looking to create a dynamic URL whereby Excel will have two cell which represent the start date and end date, which are to form part of the websire URL. (Presently I have to manually change the URL to change the date ranges).
How do I create the macro and iqy to make the URL dynamic?
Thanks
steve