Referencing an Excel Name from a different Workbook in VBA
 

For my business I am trying to work with two separate workbooks. One
for Data and the other for Reports. What is the code to reference a
workbook name in the Data workbook with out opening it. What I tried
did not work but here it is:
X = Excel.Application.Workbooks("Data").Range(Variable Name).Value