Re: Copy folder and paste to another folder

Thanks alot Bob..

"Bob Phillips" wrote:

> Dim oFSO As Object
> Set oFSO = CreateObject("Scripting.FileSystemObject")
> oFSO.CopyFolder "c:\mydocuments\*\*", "c:\tempfolder\", True
>
>
> --
> HTH
>
> Bob Phillips
>
> "ddiicc" <ddiicc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D6753682-5B56-4905-B63C-AE513CFB3C63@xxxxxxxxxxxxxxxx
> > Hi there,
> > Can anyone kindly tell me what is the script for the macro,
> > for copying a folder, then pasting and overwrite to another folder.
> >
> > Pls help
>
>
>
.

Relevant Pages

  • Re: Select Folder - Simples Method
    ... HTH ... Bob Phillips ... > Any chance you provide a couple more lines of code as an example? ... >> What is the best method to allow the user to select a folder? ...
    (microsoft.public.excel.programming)
  • Re: VLOOKUP into another workbook
    ... No it is worksheet formula. ... > Is that code for use in VBA to get a value from an xls in another folder? ... > "Bob Phillips" wrote in message ... >>> Larry Mehl ...
    (microsoft.public.excel.programming)
  • Re: Select Folder - Simples Method
    ... I also included the API method for pre-XP systems. ... > HTH ... > Bob Phillips ... >>> What is the best method to allow the user to select a folder? ...
    (microsoft.public.excel.programming)
  • Re: Loop through all files in a folder
    ... "Bob Phillips" wrote in message ... > Dim sFolder As String ... >> I need to process all the files in a particular folder. ... >> Please reply to newsgroup, ...
    (microsoft.public.excel.programming)
  • Re: Sub folder lList
    ... HTH ... Bob Phillips ... is there any way to amend the code to return only the folder name ...
    (microsoft.public.excel.programming)