Parameter to reference a certain cell to input the date into a URL

[robersha]

Hello Everyone.

I have searched the web with no luck on finding an answer on what I need to do. Here is hoping someone on here can help me out.

I have a workbook that is pulling data for every hour of the day from an internal website. The macro is built to pull data 24 times (each hour)

ex.(http://url/[""2014/04/01""]/starthour0/endhour1/)
(http://url/[""2014/04/01""]/starthour1/endhour2/)
(http://url/[""2014/04/01""]/starthour2/endhour3/) and so on.

What I am trying to do is set up a parameter that will reference a certain cell (Master!K5) which will contain the date I need to pull. I want to be able to have that cell referenced automatically and input the date for each URL in the macro.

Is this a possibility? Any and all advice appreciated!

Thanks in advance!

 

[pbornemeier]

The code on this page could be modified to do what you want: http://www.jpsoftwaretech.com/an-exploration-of-ie-browser-methods-part-ii/

 

[robersha]

Thanks for your help. I was able to find an answer after an extensive Google Search. Here is what I found:

If the URL you are pulling data from has a date within, replace the date with the following code:

" & Format(Range("K5"), "yyyy/mm/dd") & "

So if the website is "http://www.google.com/2014/04/16/search/awlfkl", your code would look like:

"http://www.google.com/" & Format(Range("K5"), "yyyy/mm/dd") & "/search/awlfkl"

This will allow you to reference a certain cell on your sheet.