Does anyone have a way to cycle throught a folder of
files that are on my computer?

What I want to do is open the first file in a specific
folder, perform a couple of functions, save, close and
then open the next file in line to perform the same set
of functions.

I have a alot of files and don't want to have to open
each one seperatly.

Chet

Hi Chet

Try this for the files in the folder C:\Data

Sub TestFile1()
Dim mybook As Workbook
Dim FNames As String
Dim MyPath As String
Dim SaveDriveDir As String

SaveDriveDir = CurDir
MyPath = "C:\Data"
ChDrive MyPath
ChDir MyPath
FNames = Dir("*.xls")
If Len(FNames) = 0 Then
MsgBox "No files in the Directory"
ChDrive SaveDriveDir
ChDir SaveDriveDir
Exit Sub
End If

Application.ScreenUpdating = False
Do While FNames < ""
Set mybook = Workbooks.Open(FNames)

'your code
MsgBox mybook.Name

mybook.Close False
FNames = Dir()
Loop
ChDrive SaveDriveDir
ChDir SaveDriveDir
Application.ScreenUpdating = True
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chet" wrote in message ...
Does anyone have a way to cycle throught a folder of
files that are on my computer?

What I want to do is open the first file in a specific
folder, perform a couple of functions, save, close and
then open the next file in line to perform the same set
of functions.

I have a alot of files and don't want to have to open
each one seperatly.

Chet