Re: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-17 Thread pavan Kumar
ps.com [mailto:excel-macros@googlegroups.com] > On Behalf Of pavan Kumar > Sent: Apr/Mon/2012 09:04 > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Folder Structure - VBA Code > > HI Rajan, > > Please find the attached file.I have run the macro and unable to get the

RE: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread Rajan_Verma
cel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Folder Structure - VBA Code > > HI Rajan, > > Awesome its working fine as per my requirement, need a small > correction, the subfolder's is not working for more than one folder, > sorry I am not so good @ VBA h

Re: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
For Each objFl In objFldLoop.Files >> Range("A1").Offset(lngCounter, 1).Value = objFl.Name >> lngCounter = lngCounter + 1 >> Next >> LoopThroughEachFolder objFldLoop >> Next >> End

RE: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread Rajan_Verma
t;> Set ObjFolder = objFso.GetFolder("C:\PenDrive\") >> Range("A1").Offset(lngCounter).Value = ObjFolder.Path >> LoopThroughEachFolder ObjFolder >> >> End Sub >> >> Function LoopThroughEachFolder(fldFolder As Object) >> >> For Each objFldLoop In fldFolder.subFolders >> lngCounter = lngCounter + 1 >> Range("A1&qu

Re: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
ldLoop.Path > For Each objFl In objFldLoop.Files > Range("A1").Offset(lngCounter, 1).Value = objFl.Name > lngCounter = lngCounter + 1 > Next > LoopThroughEachFolder objFldLoop > Next > End Function > > -Original Mess

RE: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread Rajan_Verma
-macros@googlegroups.com] On Behalf Of pavan Kumar Sent: Apr/Mon/2012 08:20 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Folder Structure - VBA Code HI Rajan, Thanks for the replay, its working fine, i need little more help on the same, i like to have the folder contains in the next

Re: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
== > > > > Rajan. > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of pavan Kumar > Sent: Apr/Mon/2012 07:45 > To: excel-macros > Subject: $

RE: $$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread Rajan_Verma
age- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pavan Kumar Sent: Apr/Mon/2012 07:45 To: excel-macros Subject: $$Excel-Macros$$ Folder Structure - VBA Code HI Group, I am looking for a VBA code to get the Folder Structure, name and type (the code also needs to ge

$$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
HI Group, I am looking for a VBA code to get the Folder Structure, name and type (the code also needs to get the folder structure of Zip files too) Exmpl: C:\OLD\Main\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\SF3\ C:\OLD\Ma

$$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
HI Group, I am looking for a VBA code to get the Folder Structure, name and type (the code also needs to get the folder structure of Zip files too) Exmpl: C:\OLD\Main\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\SF3\ C:\OLD\Ma

$$Excel-Macros$$ Folder Structure - VBA Code

2012-04-16 Thread pavan Kumar
HI Group, I am looking for a VBA code to get the Folder Structure, name and type (the code also needs to get the folder structure of Zip files too) Exmpl: C:\OLD\Main\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\ C:\OLD\Main\SF1\SF2\SF3\ C:\OLD\Ma