Thanks Paul, thanks for your code I got another one :)
Sub ProcessFiles()
Dim Filename, Pathname As String
Dim wb As Workbook
Pathname = "C:\Users\pc\Desktop\nov\NOV 01ST TO 19TH\"
Filename = Dir(Pathname & "*.xlsx")
Do While Filename <> ""
Workbooks.Open (P
you can,
As long as ever you can.” - John Wesley
-
From: Mandeep Baluja
>To: excel-macros@googlegroups.com
>Sent: Tuesday, November 25, 2014 5:20 AM
>Subject: $$Excel-Macros$$ Re: Folder looping
>
>
>
>Sub ProcessFiles()
>Dim Filename, Pat
Sub ProcessFiles()
Dim Filename, Pathname As String
Dim wb As Workbook
Pathname = "C:\Users\pc\Desktop\nov\NOV 01ST TO 19TH\"
Filename = Dir(Pathname & "*.xlsx")
Do While Filename <> ""
Workbooks.Open (Pathname & Filename)
Filename = Dir()
Loop
En
