Read in data from one file to another

my Name is Sebastian. I'm from Germany.
I have to tell my problem here, because the german side is currently down

my Problem:
I have 2 Excel files. One with the macro-code and another one.
The one with the macro is named "Book1.xlsx" and the other one is named "Book2.xlsx".
The name of the second file (in this case Book2) change weekly. But the name of the sheet in which are my data is always the same (in this case "sheet1").

For my understanding:
- I start the macro in Book1.
- The macro ask me for the other file with the data i need
- I open the file (Book2 in this case)
- Now the macro should read out data from Book2(table) an put it into Book1 (table)
- After read out a area with no entry --> read out should finish or after 16 columns.
- After read out the files from the table the macro should close the Book2.


This is my file, can anyone take a look at this?
[I]

Please Login or Register  to view this content.

one more question, can i declare two variables? like i & j ?
Like: i is from 4 to 16 and j is from 6 to 18 ? or should i write "i+2" instead of j ?

sorry for my bad english. I try my best

If i only use the same file instead of "fileselection" it works. But as mentioned before, this filename changes every week

Please Login or Register  to view this content.

So i need the first part of the code for the fileselection

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Please read all the forum rules. You will find it is ok to "bump" threads, but it is recommended that you wait at least 24 hours before doing so. Many of our members are worldwide and are active on the forum as time and personal needs/work permits. Be patient. We are all volunteers here with other lives.

ok, thank you

is this problem so difficult? or to easy?

hm, what a shame

You're impatience is quite rude.


You can't have code in a xlsx workbook.

Please Login or Register  to view this content.

Yes, that's correct.