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("R
FlipperTest.xls
ExtractionTest.xlsx
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("R
FlipperTest.xls
ExtractionTest.xlsx
Microsoft Excel
Last Comment
Ray Erden
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok I guess I am good now so no any variations to this question. Thanks for the help!
ASKER
Thank you!
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!