If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Select and import Data from multiple tabs in closed workbook VBA

Thread starter sjk1193
Start date Nov 13, 2018
Tags

closed data file tab vba

sjk1193

New Member

Nov 13, 2018

Hi there,

I need to have a message box pop up so that I can select a CLOSED excel file where my data is located ( this file will not always be the same which is why I need to be able to choose it).

I then need to copy data from the 1st tab in the CLOSED sheet( without specifying its name, because it might change) and then paste the data to my current excel file( where I'm writing the current VBA code) .

After I have gotten the data from the 1st tab of the closed sheet I need to go to the next tab( and so on) and repeat the process.

I'm not sure how to reference the closed and open workbooks.

Please let me know if this is possible