VB code to prompt user to enter file name

[easy_times]

Hi, I've got a macro from which I want to open another file to retrieve data from, the data source file changes name every month so I want some code that will simply prompt the user to enter the path and file name each time the macro runs? Much thanks in advance

 

[Dragracer]

This is simple but works.

<pre>
Sub openfile()
Application.Dialogs(xlDialogOpen).Show
End Sub
</pre>

 

[Colo]

Hi easy_times,

Please try this.

<pre>
Dim strFileName As String

'Your Code here

strFileName = Application.GetOpenFilename("Microsoft Excel Files (*.xls), *.xls")
If strFileName = "False" Then Exit Sub
Workbooks.Open (strFileName)

' Your code here
</pre>

 

[easy_times]

THanks Guys, I can make use of both of those, cheers

Easy_times