G
Guest
Hi,
I currently run an access 2000 database which imports files which are called
fullmonthnameDay.txt ie: October01.txt. I have macros which does this fine
however
what I was wandering was instead of numerous imports's in macros is there
any VBA code which I could use to do this job?
so the VBA code would look through the relevant directory depending on the
month,
and import the newest file only.
any pointers or code snipits would be appreciated...
Cheers
I currently run an access 2000 database which imports files which are called
fullmonthnameDay.txt ie: October01.txt. I have macros which does this fine
however
what I was wandering was instead of numerous imports's in macros is there
any VBA code which I could use to do this job?
so the VBA code would look through the relevant directory depending on the
month,
and import the newest file only.
any pointers or code snipits would be appreciated...
Cheers