Assigning a cell value to a variable - between different workbooks

How, without opening the source workbook, copy the contents of a cell and put it in a variable in the destination workbook?

Example:

Please Login or Register  to view this content.

The result is ='c:\code\[example.xlsx]Sheet1'!R2C1
and not the value XPTO

If I assign the reference to a cell directly, it work:

Please Login or Register  to view this content.

The result is XPTO

Hello...

if you do:

Please Login or Register  to view this content.

The valueX will be a string with the whole path assigned, not the reference.

Try this way:

Please Login or Register  to view this content.