Loop Through all files in folder only finding first file

**Optional_karl** · 09-02-2016, 05:31 AM

Hello Everyone,

I've got the below code that is looping through a series of XLS files in a specified location and saving them as a CSV file in a different location. The code works fine for the first file, but the loop doesn't find the next file. i have no idea what i'm missing right now....

There are several files in the pickup location, all '.xls', but only the first one, alphabetically, is being pulled into the Dir()

Please Login or Register  to view this content.

Any help please?

**YasserKhalil** · 09-02-2016, 07:28 AM

I don't know what is the problem in your code.. I think you missed some parts for the code
Can you provide us the link for this code

Generally try the following code to do the task

Please Login or Register  to view this content.

Loop Through all files in folder only finding first file

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through all files in folder only finding first file

Re: Loop Through all files in folder only finding first file

Thread Information

Users Browsing this Thread

Similar Threads

Choose a Folder and Loop a Sub for all files in the chosen folder

[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

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

Loop through files in a folder and copy 2 rows from each file(xlsx) in a master file(xlsx)

Loop through each folder and then loop through each file to find file with certain keyword

VBA Loop for a folder of all the files, Loop all the worksheet in each workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions