Re: $$Excel-Macros$$ Please help on FileName = Dir()

2013-12-05 Thread maksood alam
------ > > *From:* maksood alam <786maks...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 4, 2013 2:05 PM > *Subject:* $$Excel-Macros$$ Please help on FileName = Dir() > > Hi Guys, > > Can anyone please

Re: $$Excel-Macros$$ Please help on FileName = Dir()

2013-12-05 Thread Paul Schreiner
, To all the people you can, As long as ever you can.” - John Wesley - > > From: maksood alam <786maks...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wednesday, December 4, 2013 2:05 PM >Subject: $$Excel-Macros$$ Please help on FileName = Dir() >

$$Excel-Macros$$ Please help on FileName = Dir()

2013-12-04 Thread maksood alam
Hi Guys, Can anyone please explaint what *FileName = Dir() *is doing in below code. Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As Long) Dim Dirs() As String Dim NumDirs As Long Dim FileName As String Dim PathAndName As String Dim i As Long Dim Filesize As Double ' Mak