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

[Goodstart14]

Hi,
I want to combine multi workbooks into master workbook but I want to combine only sheet3.
Multi workbooks have the same type.
Could you give me any advice?
Thanks

[HaHoBe]

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

[Goodstart14]

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

[Goodstart14]

Sorry.
I did

[HaHoBe]

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

[Goodstart14]

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

Thank you so much!!
I tried this code and message box camp up. It says Excel couldn't find the path.
These multi workbooks are protected by all same password.
Do you think this cause the problem?
If this is, how I can unprotected this workbooks?

Thanks in advance!

[HaHoBe]

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

[Goodstart14]

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

[xlbiznes]

Hi,

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

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

[HaHoBe]

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

[Goodstart14]

Thanks!!
sorry for late response.
I was out of town.
Thanks again!