Lonnie Johnson
prodevmg at yahoo.com
Thu Oct 20 09:38:09 CDT 2005
Hello Great Ones, I use the following to zip files and folders. Is there code to zip "specific" files in a folder? CODE Dim strAppName As String Dim FilesToBeZipped As String Dim NameOfNewZipFile As String strAppName = "C:\Program Files\WinZip\WINZIP32.EXE" FilesToBeZipped = "H:\ACCOUNT\CORP_RELO\Databases\" Dim toLoc As String Dim newDB As String toLoc = "C:\BackUp\Databases\" NameOfNewZipFile1 = toLoc1 & newDB Call Shell(strAppName & " -A -r -P " & NameOfNewZipFile & " " & FilesToBeZipped, 1) May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free.