I am receiving workbooks from someone who is using the filename a
follows : <TodaysDate NW AB.XLS
For example today i received a workbook with this filname...
180704 NW AB.xls
and tomorrow i will receive a workbook named
190704 NW AB.xls
Also the received files are stored in C:\CASTLE\NORTH WEST\
Please could someone tell me how to programmatically write some code t
auto load the file received without having to browse for th
file.Obviously it has something to do with Format Date but am unsure f
exactly how to do this. Also before loading the file i want to copy th
received file into D:\RECEIVED\NORTH WEST\
Thanks in advance
--
Message posted from
http://www.ExcelForum.com