J
jj
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.Wookbooks("Data").Range(VariableName).Value
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.Wookbooks("Data").Range(VariableName).Value