Copy a file in a macro

FileSystemObject.CopyFile “c:\mydocuments\letters\*.doc”, “c:\tempfolder\”

Please note that wildcards can only be used with the actual file names and not in variables

Leave a Reply