[AccessD] Zipping Certain Files

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.


More information about the AccessD mailing list