There are lots of help topics on this if you search on the forum. In summary - the task is not as straightforward as you might hope as the contents of a cell are both the formula (ie =A1+ B1) and the answer (5). You have two main options that work reliably:
- Make a temporary copy of a sheet using “Paste - Special - Values” in excel which has no formulas and process from there (I do this if there are many variables in formulas that need to be copied)
- Use the process below for copying one or two variables :- use background action to position active cell then use clipboard to retrieve the value.
Here is a working example for A1 = 2, B1 = 3, C1 = A1+B1
Don’t forget to put quotation marks around the file path: “c:\….file path” when opening.