copy rows from 42 workbooks into masterworkbook

Hey

I,m looking for a more elegant solution to the macro pasted below. The idea is to copy 6 rows from 42 workbooks in one single workbook without having to copy the below macro 42 times. All files will be in one folder. So the steps will be:

1 open first workbook
2 mark rows
3 copy rows
4 insert into active workbook
5 close workbook
6 repeat 42 times with every file in directory

Please Login or Register  to view this content.

Something like this should work:

Please Login or Register  to view this content.

Hmmm. no luck. what if i upload master workbook and one of the dataimport workbooks?

Describe what "no luck" means.

no execution of makro. Just to clarify under statement

Please Login or Register  to view this content.

I replace everything inside the colon with whole filename? the first filename in the folder is "trafikkinntektsmodell B2013 AL.xlsm". Every file after that will have same name except the two letter abbreviation

That line of code should work just fine. The * wildcards in the filename should allow any names. You could be a little more specific, but it's not really necessary:

Please Login or Register  to view this content.

I would recommend using F8 to step through that macro one line of code at a time and see which line of code does NOT do what it is supposed to. After you pass the Fname = code, hover your mouse over fNAME and you should see the name of the file it found. Anything?

So, VBA is not finding any files in that folder. You did edit the folder highlighted in red in the original macro to point to your actual folder?

I don't do any "over network" work, so if the problem is related to running the VBA over a network path I won't be much help with that. Only tip I can think of would be to map the network drive to your own system as new drive so you can use standard Windows path formatting:

Please Login or Register  to view this content.

ok, well, I use this kind of code in 100s of macros. Something doesn't match what is actually in your working environment.

Strange. If could use the rest of the code after this then... would that work? And copy 42 times with but just changing filename?

Please Login or Register  to view this content.

Ok, I've added code tags to TWO of your prior posts. It's your turn. Please correct the post above as per forum rules.

EDIT post #15, highlight the code, click the # icon.

Take a moment and read through the forum rules, you are expected to know and follow them. Thanks.

Ping back when you have corrected it.

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.