Hello

I just wonder if it is possible to retrieve data from a closed workbook located on a website using the John Walkenbach's function?

Function GetValue(Path, File, Sheet, Ref) 
     'Retrieves a value from a closed workbook
    Dim Arg As String 
     'Make sure the file exists
    If Right(Path, 1) <> "\" Then Path = Path & "\" 
    If Dir(Path & File) = "" Then 
        GetValue = "File not  Found" 
        Exit Function 
    End If 
     'Create the argument
    Arg = "'" & Path & "[" & File & "]" & Sheet & "'!" & Range(Ref.Range("A1").Address(, , xlR1C1)) 
     'Execute XLM macro
    GetValue = ExecuteExcel4Macro(Arg) 
End Function
Thanks