Hi all,
I currently have a line of code which will pull data from a closed workbook without opening it. Its part of a loop that goes through each file in the directory.
The code is
This works by putting the formula into Cell A(i) which in turn returns the value from the closed book.
My Question is rather than putting the formula into the cell and have that pull the data is it possible to alter the code slightly so that the value goes into A(i) rather than the formula
I currently have a line of code which will pull data from a closed workbook without opening it. Its part of a loop that goes through each file in the directory.
The code is
Excel Formula:
range("A" & i).Formula = "=INDEX('" & MyPath & "\[" & f.Name & "]HrsWrk'!D:D,14,1)"
This works by putting the formula into Cell A(i) which in turn returns the value from the closed book.
My Question is rather than putting the formula into the cell and have that pull the data is it possible to alter the code slightly so that the value goes into A(i) rather than the formula