Thread: ExecuteExcel4Macro

Hi,

I am trying to read some values from a closed workbook.

I use the following code

Dim Data As String
    
    On Error GoTo label:
    'Data = "'" & Path & "[" & File & "]" & Sheet & "'!" & "$A$4"
    Data = """" & "'" & Path & "[" & File & "]" & Sheet & "'!" & Range("$A$4").Range("A1").Address(, , xlR1C1) & """"

    GetData = ExecuteExcel4Macro(Data)
label:
    MsgBox Err.Number & Err.Description

But GetData always have this value 'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY[Upload.xla]Hidden'!R4C1

instead of getting the value from the address R4C1 in hidden sheet in Upload addin , it always has the as path to address which is "'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY[CostUpload.xla]Hidden'!R4C1"

Can u anyone tell me where I am going wrong??

As a minimum, you're missing the backslash after LIBRARY in the path.