[lijon]

Hi Folks,
I wrote the following macro the old-fashioned way (I recorded it!). It looks up and opens a file in another directory.
but here's the thing: the file name will change! Is there a way I can modify the code to just get the MOST RECENT wk3 file? or ignore parts of the file name?
Optimally, it would ignore the "391640" part, maybe just look for something with today's date?

Appreciate any input!!!
L

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 6/4/2008 by L
'
Workbooks.Open Filename:= _
"W:\mtm_trade.391640_1.7595_SW.04-Jun-08.WAILER_.WAILER_.wk3"

Range("B5").Select
blah blah blah
blah blah blah

End Sub

[stuschmied]

Hey,

Using code you could look into your directory for a file with a particular name or filter. Then set a variable with that name and use the macro to call code that opens the file with that variable name.

Hope this helps.