I have two sample files attached for this question, FlipperTes
t file is the one that needs to get data in from the ExtractionTest
file. On the FlipperTest file, on Menu tab there is Extract
button. My goal is to get the specified data values from ExtractionTest
file into FlipperTest
file by using the method displayed in module2 of the FlipperTest
I know am missing something like file location or similar to make it work and need help with that. The values on ExtractionTest
file are in A1 to A5 and I need to get them into Retrieve tab of the FlipperTest
file in row 3 under their corresponding titles. Assume that FlipperTest
file is located in FolderA and ExtractionTest
file is located in FolderB.
I need to achieve this by using the below method, there should not be an option for the user to specify the file location manually via browse option and Excel should open the folder, then open the file and extract the value in the specified range.
Cells(RL, 1).Value = Workbooks(DataFile).Worksh