giving a direction to VBA to open a specific file

[an89as]

Hello Everyone,

I would appreciate if someone guide me to code a direction to VBA excel to open a file in specific file within my computer.

Please make it simple as I am a beginner in the VBA.

Thanks in advance!

[arnelgp]

here is a sample:

Private Sub test2()
    Dim strFile As String
    With Application.FileDialog(msoFileDialogFilePicker)
        'Makes sure the user can select only one file
        .AllowMultiSelect = False
        'Filter to just the following types of files to narrow down selection options
        .Filters.Add "All Files", "*.*", 1
        'Show the dialog box
        .Show
        
        'Store in fullpath variable
        strFile = .SelectedItems.Item(1)
        'if a file is selected then Open it
        If Len(strFile) <> 0 Then
            CreateObject("Shell.Application").ShellExecute strFile, "", "", "Open"
        End If
    End With


End Sub