combine multi workbooks into one master workbook but I want to combine only sheet 3

Hi, Goodstart14,

Could you give me any advice?

I´m sure you won´t like the answer: use the search in this forum or google/delta/bing?

WBs to 1 Sheet or Merge data from all workbooks in a folder provide the basic codes and maybe must adapted for only doing so on a speical worksheet (either name or position inside workbook - I´d prefer the name of the sheet anyhow).

Ciao,
Holger

Please Login or Register  to view this content.

Thank you so much!!
I know I need to study more but...
Could you check this code? I don't know what is wrong.
Thanks

Hi, Goodstart14,

I wouldn´t use Path as a Variable. You should consider to use Option Explicit when using code as that would have told you about the variables you used without dimming / filling them.

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Goodstart14,

upps - my bad, did correct all the varibales as I should have done.

Please Login or Register  to view this content.

You need not quote full posts.

CIao,
Holger

Thanks

I got "Option explicit" but I had to define "Path", so I put Dim Past As String in your code.

***************************
Sorry, I tried again and it worked.
This code import each Sheet3 in masterExcel's each sheet, like Sheet3(3), Sheet3(2), and Sheet3(1).
These multi excel spreadsheets are protected by password but it seems it doesn't care.

Once I import Sheet3, then I want to these excel spreadsheets in "Imported" folder so I don't import twice.
How can I achieve this?

Thanks

Hi,

Have a look at this solution that is in line with you requirement.

http://www.excelforum.com/excel-prog...ml#post3515486

Hi, Goodstart14,

moving the files may be done like this:

Please Login or Register  to view this content.

The protection of a worksheet does not matter when copying - it just remains intact. If you want the sheets unprotected you may run another routine after importing like

Please Login or Register  to view this content.

Ciao,
Holger