I am trying to get a value from a closed workbook in Excel VBA on a Windows 10/64 PC with Office 365.
The data is in a single cell named "TestText".
Whenever I run the function below, instead of populating "getText$", Excel opens a file dialog box with the title
"Update Values: Data[Test2.xlsx]Sheet1". The dialog box is open to the My Documents folder.
What am I doing wrong, please?
Thank you for your help.