Hi all. I'm trying to write a macro that loops, with each pass rewriting a web query address string that uses a date. The query returns a table with one days' data. When each date's table is returned, I'll extract the data out of it, delete the query, and rewrite the string incrementing by one day, repeating 30 times.
The string needs the date in this format: March 13, 2009 is 20090313.
My problem is how to use the useful date worksheet functions within VBA and not having to calculate each next date in a cell.
Any takers? This seems like a fun bit of code...
The string needs the date in this format: March 13, 2009 is 20090313.
My problem is how to use the useful date worksheet functions within VBA and not having to calculate each next date in a cell.
Any takers? This seems like a fun bit of code...