I am writing macros to do Web Queries using Excel 2003 and downloading the
information from Anumati.com

When you type in a stock symbol at Anumati.com, you are given a new web page
to select what type of reports you want to see, Quarterly or Annually. After
you make your selection, it displays the requested report in the following
format:

http://www.anumati.com/DynamicReport...002;28/09/2002

It uses specific dates at the end of the URL for the Quarterly Report of
each company.

I originally thought that once I figured out what Year End a company was
using, I could assume Quarterly ending periods. ie. YrEnd = Dec. 31,2004 --
QtrEnd = March 31, June 30, Sept 30, Dec. 30. But as you can see from the
example above, Quarter ends don't necessarily mean last day of the month for
each 3 month period.

I built a macro that uses these dates to build a string with the correct
URL to download. But my logic breaks down when a company has non-standard
quarter or annual ending dates, ie

A2 = http://www.anumati.com/DynamicReport.aspx?id=TR&report=
A3 = Report requested (IS-Q - Income Statement Quarterly)
A4 = &dates=
A5 = quarter ending dates as determined by finding the correct year ending
date

A1 = A2&A3&A4&A5

A1 is the string that I use in the macro as the URL to download.

Is there an easier way to accomplish the same task without building a text
string to use as the URL? As I mentioned the dates can change depending on
what company you select.

I would appreciate any help.

Thanks