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
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 Priyanka,
>
> by using this macro you can move source folder with subfolder to change
> sfol = "c:\MyFolder" path.
>
>
>
>
> On Fri, Feb 17, 2012 at 3:04 PM,
Hi Priyanka,
by using this macro you can move source folder with subfolder to change
sfol = "c:\MyFolder" path.
On Fri, Feb 17, 2012 at 3:04 PM, PrIyAnKa wrote:
> Dear Noorain
>
> I have files in different sub folders...
>
> as per below macro i may need to set number of sfol path ...
>
> sf
Dear Noorain
I have files in different sub folders...
as per below macro i may need to set number of sfol path ...
sfol = "c:\MyFolder" ' change to match the source folder path
Kindly suggest if i m wrong...
On Fri, Feb 17, 2012 at 12:55 PM, NOORAIN ANSARI
wrote:
> Hi Priyanka,
>
> Please try
Hi Priyanka,
Please try it..
Sub CopyFilesFolder2Folder()
Dim fso
Dim sfol As String, dfol As String
sfol = "c:\MyFolder" ' change to match the source folder path
dfol = "e:\MyFolder" ' change to match the destination folder path
Set fso = CreateObject("Scripting.FileSystemObject")
On Error Resum
ok
Thanks viper for the help..
it works perfectly. need one of your favor also ,if i need to move the
files from one drive to another drive then how it could be possible?
I have tried the below one
CLS
C:
CD move /-y "C:\Documents and
Settings\Administrator\Desktop\sample\*sample.xlsx" "D:\New
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
if your file name is exactly sample.xlsx then use
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
On Thu, Feb 16, 2012 at 6:07 PM, The Viper wrote:
> is "C:\Documents and Settings\priyanka\desktop\sample" the right path of
> your master folder?
>
> if not,
is "C:\Documents and Settings\priyanka\desktop\sample" the right path of
your master folder?
if not, change the path first and then file name
On Thu, Feb 16, 2012 at 6:02 PM, PrIyAnKa wrote:
> What i need to change in it? only file name
>
> Only red highlighted words need to change ?
>
>
>
>
What i need to change in it? only file name
Only red highlighted words need to change ?
CLS
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
change the path and you can use the wildcards like below
DEL /q /s /f "*sample.xlsx"
or
DEL /q /s /f "sample*.xlsx"
paste the below code in notepad and save it with .bat extension and run
CLS
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
change the path and you can use the wildcards like below
DEL /q /s /f "*sample.xlsx"
or
DEL /q /s /f "sample*.xlsx"
On Thu, Feb 16
Dear Laxman
Will it delete folder? or excel file from folders?
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 specific
excel file, without giving each 239 folders path
On Thu, Fe
Dear PrIyANkAtyr this
Sub Delete_Folders_FS()
objFolder = "D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*"
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.deletefolder objFolder
End Sub
LAKSHMAN
From: PrIyAnKa
To: excel-macros@
13 matches
Mail list logo
