Macro copying from files with different names

[The Intern]

Hello everyone,

I want a Macro to copy into a specific file out of another one. The problem is that the other file changes, every new version has another name.
I thought about including a cell in the target file, in which the user can type the name of the file and the macro should use this information to copy out of this file.
Is there any possiblity to do so?
Perhaps with Dim copy as ??

Thanks in advance,

The Intern

[nihitsk]

Hi Intern,

Do you want to merge different worlsheets to a single one or Merge different sheets of same workbook to a single sheet ?

[The Intern]

Sorry, if my question is difficult to understand.
I want to copy from one workbook into workbook A. The problem is that I don't know the name of workbook which is the source. Thats why I want to include this cell into workbook A, where you can type the name of the source-file. The macro (in workbook A) should take the name out of the cell automaticly and copy from the workbook with this specific name.

[nihitsk]

Here is the code..

It will ask you to add select the files which u want to append n your workbook..

Cheers..

Please Login or Register  to view this content.

[The Intern]

Thank you very much for your help!!
This macro is really advanced...and to be honest, I am a beginner
So I don't really understand it. Would you mind explaining it a bit further?
I tried to start it in order to see what it is doing, but it always says: Label is not defined.
Do I have to give the Sub a specific name?
Thanks again,

The Intern