How do I open a workbook by newest date?

S

Sarah

In a folder, there are several files with similar names and I need to open
the most recently created file. No, I don't want anything from the "Recently
Used" collection. Now, I have an input box to receive the date in the right
format, but it would be more efficient to just have VB go open the right one.
Here's what I have now: ChDir "D:\Users\Me\My Documents\MMM\METRICS_DATA"
s = InputBox("What is the date on the METRICS/OPERATIONAL_DATA file?
Please use this format: 2008_09")
If Application.Workbooks("D:\Users\Me\My
Documents\MMM\METRICS_DATA\OPERATIONAL_DATA_" & s & ".xls") = True Then
Application.Workbooks.Open _
("D:\Users\Me\My Documents\MMM\METRICS_DATA\OPERATIONAL_DATA_" &
s & ".xls")
End If
If "D:\Users\Me\My Documents\MMM\METRICS_DATA_" & s & ".xls" = True Then
Workbooks.Open Filename:= _
"D:\Users\Me\My Documents\MMM\METRICS_DATA_" & s & ".xls"
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Export Report with Graph to Excel error 2495 1
Send one tab of workbook in email 1
open CSV.file 15
how do i loop thru all the worksheets in 2 files one by one 0
How to get an Excel file to save without the VB 2
Date format Workbooks Open 1
Open four Wbooks, copy four columns from each to Master Wbook 16

Top