Macro for opening files that changes names
 

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

Macro for opening files that changes names
 

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

" wrote:

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