Trying to reference a cell in another workbook as part of a formula in VBA

Hi all. I'm trying to reference another cell from another workbook within a formula in VBA.

What I'm starting out with is

Please Login or Register  to view this content.

That part works just fine. It takes the value four columns from the left of the active cell and subtracts 2% from it. What I want to do is replace the "-2%" part with a reference to a cell in another workbook which will already be open so that it subtracts that value instead of the 2%. What I've tried are:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Neither of those seem to work. The specific cell in the workbook I want to reference isn't important (it could be Q1, A1, B3, Z54, whatever) as is the ability to reference a cell of my choice.

Any help would be greatly appreciated!

Hi,

Please Login or Register  to view this content.

where "Example1.xlsm" is the name of the "other" workbook, the cell used is located in the 1st sheet E3.

Please mark this thread as SOLVED if this answer solves this problem.

Regards