Select and import Data from multiple tabs in closed workbook VBA

[sjk1193]

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