Hi all,
I'm trying to import to files into a database and this would need to happen on a daily basis. The files naming scheme works like this:
[clientname]_a date(mmddyyyy format)_"00:00 time"
Basically we get this file multiple times per day and what I want to know is this. Is there a way that I can always have it import the file which is current day and lists 2:30pm as the time, and another file which will always be the one from 9:00pm the previous business day.
for instance is we are talking about today and yesterday the two files will be named like this:
"name"_04162013_1430.xls (today's file)
and
"name"_04152013_2100.xls (prior business day's file)
Unfortunately I have zero VBA experience and most of my experience in Access has been using Macros and just the ribbon import tools so your patience and expertise is greatly appreciated. Let me know if I can provide any addition info.
Thanks,
NH