Hi,
I am trying to read some values from a closed workbook.
I use the following code
But GetData always have this value 'C:\Program Files (x86)\Microsoft Office\Office12\LIBRARY[Upload.xla]Hidden'!R4C1Please Login or Register to view this content.
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??
Bookmarks