Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: Programatically Launch XP zip function

    Is there any way to use vba to zip a file using the built-in zip utility that comes with XP?

    I am using command line options for winzip but distribution may become a problem or previous installed copies of lower versions may as well.

    any help wouldbe appreciated.

    is there an API?
    Dale Houston, TX

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    POW

    Google is your friend! If you get this working let us know. It might be a great little addition to the Access Code Bank
    bonus
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    The following code maybe helpful

    This code opens winzip and asks for the zip file where the report.mdb is to be zipped. You may have to change the location of the winzip32.exe

    Sub test_zip()

    Dim app_name As String
    app_name = "C:\Program Files\WinZip\winzip32.exe c:\demos\report.mdb"

    Call Shell(app_name, 1)

    End Sub

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    As mentioned - I cannot use winzip - distribution issues, but I am about 90% complete in getting the vba/windows xp version working and I will post that code.
    Dale Houston, TX

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    try
    http://www.vbaccelerator.com
    they used the dll to win Zip

    Its not that hard to get you head around
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •