Link to home
Start Free TrialLog in
Avatar of Ray Erden
Ray ErdenFlag for United States of America

asked on

Data Transfer Between Two Excel Workbooks

I have two sample files attached for this question, FlipperTest 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 file.  

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.

ThisWorkbook.Worksheets("Retrieve").Cells(RL, 1).Value = Workbooks(DataFile).Worksheets("Summary").Range("A1").Value
FlipperTest.xls
ExtractionTest.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Robberbaron (robr)
Robberbaron (robr)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ray Erden

ASKER

Robberbaron,

I have just solved this question now and almost the same time you have posted your solution where I was about to delete the question and re-post more involved version of it. If you could please bear with me I will post expanded version of my original question once I structure it well. Thank you!
Ok I guess I am good now so no any variations to this question. Thanks for the help!
Thank you!