Issues with VBA code to import multiple csv files

Nice "hole punch" effect, is this code perhaps from perforated cards of Univac ?

Originally Posted by porucha vevrku

Nice "hole punch" effect, is this code perhaps from perforated cards of Univac ?

Yeah we all have to start somewhere

Originally Posted by vbabeginner123

... but when I tried it again it failed for some reason ...
The code is built in two loops because the names of the csv files are in two groups with two different prefixes + year ...

1. But what's the matter ? What is the reason of this "reason" ?
2. Which groups ? What are these groups ?
3. Something more about it.

Never mind guys, I found the mistake today after trying to describe the script and issue in detail It was a spelling mistake

But I do have two small questions that I have not been able to work out.

1. Is there a way to set the for-loop variable (i in my script) to be certain values that you can f.x. write into the Excel-sheet, instead of just jumping in a range with a certain step size? I imagine something like:

Please Login or Register  to view this content.

2. Do you see a more elegant way to write the code instead of having two for-loops?
The reason for the two loops is that I have csv files that are called "name1_year" that should go to sheet "name1*_year" and then csv files called "name2_year" that should go to sheet "name2*_year". Year = 20, 25, 30 and 35.
But I can't seem to change the names within the same loop...

Best regards.

Hi !

Answer for both questions : just using a For Each loop … (a VBA inner help must read !)

Example for 1) : For Each V in [{20,35,40}] …

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !