B
Bunky
I have an application that I need to pull data from on a weekly basis. The
application creates a file daily with a name such as AgentData031509.xls.
Since I pull the data weekly, I want to pull 7 AgentData files starting on
the most recent Sunday and working backward for 7 days. Since the name on
the file changes each day, does anyone have any ideas on how I can automate
this import?
Thanks for your assistance!
application creates a file daily with a name such as AgentData031509.xls.
Since I pull the data weekly, I want to pull 7 AgentData files starting on
the most recent Sunday and working backward for 7 days. Since the name on
the file changes each day, does anyone have any ideas on how I can automate
this import?
Thanks for your assistance!