Hi all,

I just need to open a file in a local network shared folder. How to open it. I have posted code to open in local drive(C:/) , but i want to open in a local shared network folder wher the file is saved in another machine.

Plz help!

'To select the previous weeks report file manually
    Dim Filename As Variant
    Dim Filter As String
    Dim Title As String
    Title = "Select a Thymoglobulin previous week File to Open"
    'Select Start Drive & Path
    ChDrive ("C")
    ChDir ("C:\Documents and Settings\221290\Desktop\Excel\Thymoglobulin")    With Application
    'Set File Name to selected File
    Filename = .GetOpenFilename(Filter, FilterIndex, Title)
    ChDrive (Left(.DefaultFilePath, 1))
    ChDir (.DefaultFilePath)
    End With
    'Exit on Cancel

    
    'To Open the previous week report file
    Workbooks.Open Filename

Thanks in Advance!