VBA Code won't loop through all files in the folder

**VioletFlare** · 03-22-2019, 10:02 AM

I have a bunch of CSV files in one folder. The aim is to copy all the data (excluding the header row) from each file and collate them into one. Below is the code I'm currently using, the problem is the code only copies data from one file then ends completely ignoring all other files in the folder

Please Login or Register  to view this content.

I believe that the problematic line is:

Please Login or Register  to view this content.

I've come to this conclusion because belovw is the code that us to be in use and my code would loop through very folder. Though since making this change it no longer does.

Please Login or Register  to view this content.

The reason I changed the working code is because I no longer required only certain columns, but instead I need all columns to be copied into the file.

I don't understand why the range change has stopped my program from working as expected

. A solution and explanation (if possible) would be much appreciated.

**Richard Buttrey** · 03-22-2019, 11:05 AM

Hi,

You need to reset the counter to zero for every new file and change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

However, assuming the rows in the range A1:AA1 in the file being copied are contiguous and to avoid the need for the loop you could simplify this to

Please Login or Register  to view this content.

VBA Code won't loop through all files in the folder

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code won't loop through all files in the folder

Re: VBA Code won't loop through all files in the folder

Thread Information

Users Browsing this Thread

Similar Threads

Loop Code to extract information from all files in a folder to a mastersheet

Anyone can help me with code to loop through all files in a folder [DATABASE ERROR]

[SOLVED] Choose a folder and loop through all files in the chosen folder

[SOLVED] Loop Through Folder, Create Emails with Sub Folder Names in Subject, Attach files in sub

loop through all files in a folder and run code to unmerge and shift

code to loop through all .docx files in folder

Choose folder & loop through all files to copy - folder is subfolder in network drive

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions