Hi,

What is the command to copy everything in the folder C:\2009 to a drive G:
(all subfolders should be included too)
While copying, it should flash the message €œCopying €¦€� on the screen without
showing the actual files being copied. It should be done in the background.
And when it is finished, it should say €œBackup complete€�.
The messages should be larger than normal and Bold.

Berj

Not what you wanted...

But there are somethings that I don't use excel for.

I'd use windows explorer and just copy the folder to the new location.

Berj wrote:

Hi,

What is the command to copy everything in the folder C:\2009 to a drive G:
(all subfolders should be included too)
While copying, it should flash the message €œCopying €¦€� on the screen without
showing the actual files being copied. It should be done in the background.
And when it is finished, it should say €œBackup complete€�.
The messages should be larger than normal and Bold.

Berj

--

Dave Peterson

I know pal.

I just want to use it in a Macro.
After doing some steps, it has to copy some files as I click on a macro
button.
By the way. This is something I am preparing for other people who know
nothing about copying and they get lost in them, so I just want to prepare a
button for them, so that when they click, it does everything for them.



"Dave Peterson" wrote:

Not what you wanted...

But there are somethings that I don't use excel for.

I'd use windows explorer and just copy the folder to the new location.

Berj wrote:

Hi,

What is the command to copy everything in the folder C:\2009 to a drive G:
(all subfolders should be included too)
While copying, it should flash the message €œCopying €¦â‚¬Â� on the screen without
showing the actual files being copied. It should be done in the background.
And when it is finished, it should say €œBackup complete€�.
The messages should be larger than normal and Bold.

Berj

--

Dave Peterson

And to add to something that I wouldn't do <bg...

If you want to make sure that files with the same name are overwritten:

FSO.CopyFolder Source:=sFrom, Destination:=sTo, overwritefiles:=True



Dana DeLouis wrote:

What is the command to copy everything in the folder C:\2009 to a drive G:

Would this work?

Sub Demo()
Dim FSO As Object
Const sFrom = "C:\2009\"
Const sTo = "G:\MyBackup\"

Set FSO = CreateObject("Scripting.FileSystemObject")

FSO.CopyFolder sFrom, sTo
End Sub

--
HTH :)
Dana DeLouis

"Berj" wrote in message ...
I know pal.

I just want to use it in a Macro.
After doing some steps, it has to copy some files as I click on a macro
button.
By the way. This is something I am preparing for other people who know
nothing about copying and they get lost in them, so I just want to prepare a
button for them, so that when they click, it does everything for them.



"Dave Peterson" wrote:

Not what you wanted...

But there are somethings that I don't use excel for.

I'd use windows explorer and just copy the folder to the new location.

Berj wrote:

Hi,

What is the command to copy everything in the folder C:\2009 to a drive G:
(all subfolders should be included too)
While copying, it should flash the message €œCopying €¦â‚¬Â� on the screen without
showing the actual files being copied. It should be done in the background.
And when it is finished, it should say €œBackup complete€�.
The messages should be larger than normal and Bold.

Berj

--

Dave Peterson


--

Dave Peterson