Extracting values from latest closed workbook into current workbook?
Hi, having some challanges extracting values from latest workbook. Files in "C:\" have files where filenames are dates and on a weekly bases the files in this folder change. So basically the file "062215_L01.xls" will change to "062915_L01.xls" next week. I would like to get data from the latest _L01 file. Is there a way around this? Thanks
Please Login or Register to view this content.
try this code:
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Thanks p24leclerc, how can i adjust this so it takes the first Monday of the current week?Originally Posted by p24leclerc
try this code:
Please Login or Register to view this content.
change the -1 in the DataAdd function to 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks