I have some tasks that currently users must do it manually in daily bases, however since this is prone to errors, the manager would like it should get automated done via code.
1- Look for specific file in default download folder that name starts with Tables_TodaysDate_LatestNu
mber.Zip (See attached).
2- Extract it to specific folder (C:\Application)
3- Delete old File C:\Application\Tables.MDB
4- Rename extracted file (something like Tables_2017-Oct-30_2230.md
b) to Tables.MDB
Would prefer it done either by calling some DOS commands from VBA or just using native VB functions if possible.
Thanks in advance.