Hi there,

I am trying to write a a macro that will activate a window that contains a dynamic date reference. The window holds sales data but each month, the file name changes. This month it is titled "Sales APR 2013". Next month it will be "Sales MAY 2013". I'd love to write one macro that will use the current month to determine the correct file name.

Thanks,

Jordan