[AccessD] Copy a folder with VBA

Lonnie,

With a reference set to Microsoft Scripting Runtime, you can try the
following...taken from Scripting Run-Time Reference Version 3
(VBSCRIP5.CHM).  See the remarks section for "gotchas".

Syntax:
object.CopyFolder source, destination[, overwrite]

Example:
FileSystemObject.CopyFolder "c:\mydocuments\letters\*", "c:\tempfolder\"



Mark


-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
Sent: Thursday, September 11, 2003 1:31 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Copy a folder with VBA


Is there a quick or slick way to copy an entire folder to a different drive
and folder name with VBA. Simular to the FileCopy source, destination
statement?



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us



 


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software