I'm trying to get data from Cell A4 in a closed workbook named "Test1.xlsm"
When I use the name "Test1.xlsm" it gets the data
But when I put the file name "Test1.xlsm" into a string it doesn't return the data from Cell A4
Sub LoopThroughFiles_for_Total_Values()
Dim Date2 As String
Dim...