Macro for opening files that changes names

V

vikramsingh1970

Hi there,

I am new to the world of macros and was wondering if there was any way
to create a macro that could open a file which changed name daily.

Also what coding would you use if it changed directory/location too?

Kindest Regards,

Juliodenero
 
M

Mike

maybe this
Sub test()
Dim OpenAFile As FileDialog
Set OpenAFile = Application.FileDialog(msoFileDialogOpen)
With Application.FileDialog(msoFileDialogOpen)

If .Show Then .Execute
End With
End Sub
 
Top