Re: $$Excel-Macros$$ Deletion of files on specific path

PrIyAnKa Sent: Friday, February 17, 2012 4:38 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Deletion of files on specific path Dear Noorain I want to move only .xls files not the root folder also with it On Fri, Feb 17, 2012 at 3:39 PM, NOORAIN ANSARI wrote: Hi

Re: $$Excel-Macros$$ Deletion of files on specific path

gt;>>>>>> >>>>>>>> paste the below code in notepad and save it with .bat extension and >>>>>>>> run >>>>>>>> >>>>>>>> CLS >>>>>>>> C: >>>>>>>

Re: $$Excel-Macros$$ Deletion of files on specific path

uments and Settings\priyanka\desktop\sample" >>>>>>> DEL /q /s /f "sample.xlsx" >>>>>>> >>>>>>> change the path and you can use the wildcards like below >>>>>>> >>>>>>> DEL /

Re: $$Excel-Macros$$ Deletion of files on specific path

" >>>>>> or >>>>>> DEL /q /s /f "sample*.xlsx" >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Thu, Feb 16, 2012 at 5:38 PM, PrIyAnKa wrote: &

Re: $$Excel-Macros$$ Deletion of files on specific path

;>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Thu, Feb 16, 2012 at 5:38 PM, PrIyAnKa wrote: >>>>> >>>>>> Dear Laxman >>>>>> >>>>>> Will it delete folder? or excel fi

Re: $$Excel-Macros$$ Deletion of files on specific path

>>>>> and i have 239 folders and in all those folders there is a file,i want >>>>> to delete that file >>>>> >>>>> Dear All >>>>> >>>>> Can we have a macro which go through sub folders and delete any >>>>>

Re: $$Excel-Macros$$ Deletion of files on specific path

Hi, Sub kTest() Dim obWSShell As Object Dim strDTop As String Dim objFSO As Object Dim objFldr As Object Set obWSShell = CreateObject("WScript.Shell") Set objFSO = CreateObject("scripting.filesystemobject") strDTop = obWSShell.SpecialFolder

Re: $$Excel-Macros$$ Deletion of files on specific path

all those folders there is a file,i want >>>> to delete that file >>>> >>>> Dear All >>>> >>>> Can we have a macro which go through sub folders and delete any >>>> specific excel file, without giving each 239 folders path >

Re: $$Excel-Macros$$ Deletion of files on specific path

gt;> tyr this >>>> >>>> >>>> Sub Delete_Folders_FS() >>>> >>>> objFolder = "D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*" >>>> Set objFSO = CreateObject("Scripting.FileSystemObject") >>>&

Re: $$Excel-Macros$$ Deletion of files on specific path

and Settings\lakshman-\Desktop\New Folder\*.*" >>> Set objFSO = CreateObject("Scripting.FileSystemObject") >>> objFSO.deletefolder objFolder >>> >>> End Sub >>> >>> LAKSHMAN >>> >>> *From:* PrIyAnKa >>>

Re: $$Excel-Macros$$ Deletion of files on specific path

) >> >> objFolder = "D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*" >> Set objFSO = CreateObject("Scripting.FileSystemObject") >> objFSO.deletefolder objFolder >> >> End Sub >> >> LAKSHMAN >> >> *From:* PrIyAnKa >> *To:*

Re: $$Excel-Macros$$ Deletion of files on specific path

deletefolder objFolder > > End Sub > > LAKSHMAN > > *From:* PrIyAnKa > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, 16 February 2012 2:46 PM > *Subject:* $$Excel-Macros$$ Deletion of files on specific path > > Dear Team > > I have a folder named &

Re: $$Excel-Macros$$ Deletion of files on specific path

Ka To: excel-macros@googlegroups.com Sent: Thursday, 16 February 2012 2:46 PM Subject: $$Excel-Macros$$ Deletion of files on specific path Dear Team I have a folder named "ABC" on desktop, in that ABC folder i have about 239 sub folders and in that folders there is a fi

$$Excel-Macros$$ Deletion of files on specific path

Dear Team I have a folder named "ABC" on desktop, in that ABC folder i have about 239 sub folders and in that folders there is a file named".(Folder Name) Performance file .. I want to delete all those files with one macro click. Example : main folder ABC - Sub Folders : A