Hi, I wonder whether someone may be able to help me please.

I have a directory which contains 'monthly' sub folders.

Each subfolder contain two files. The first is called "SIP", the second, "Extract".

What I'd like to do is allow the user to select a 'monthly' sub folder, then the two files ("SIP" and "Extract") to open automatically.

I'm using the code below (found through a Internet search), which opens the dialog box, allowing the to search for the 'Monthly' sub folder, but I'm unsure how to automatically open the two files.

[VBA]
Sub GetFileNameFromUser()

Dim FN As String

FN = Application.GetOpenFilename("All files (*.*), *.*")

If FN = "False" Then Exit Sub

End Sub

[/VBA]

I just wondered whether someone may be able to look at this please and offer some guidance on how I may go about this.

Many thanks and kind regards

Chris