Excel to WinZip in VBA
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel to WinZip in VBA

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi Guys

    Nice on here have all my code want to add after save the ziple is zipped as save as file name already defined.

    Guess VBA - any ideas guys

    Rdgs


    PS i have seen on old board some codes but i never really have sucess with them, dont know why
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To add a file to an already created zip;

    Sub ZipFile()
    Dim ZipPath As String
    Dim ZipIt As String
    Dim Source As String
    Dim Dest As String

    ZipPath = "C:Program filesWinzip"
    Source = "C:Final.xls" '"C:myfile.xls"
    Dest = "C:tt.zip" '"C:MydestinationDir"
    'Note spaces important
    ZipIt = Shell(ZipPath & "Winzip32 -a " & Dest & " " & Source, vbNormalFocus)

    End Sub

    Some zip commands you may need to know;
    Adding files:

    The command format is:

    winzip[32].exe [-min] action [options] filename[.zip] files

    where:

    -min specifies that WinZip should run minimized. If -min is specified,

    it must be the first command line parameter.

    action

    -a For add, -f for freshen, -u for update, and -m for move. These

    actions correspond To the actions described In the section titled

    "Adding files To an Archive" in the online manual.

    options

    -r and -p correspond To the "Recurse Directories" and "Save Extra

    Directory Info" checkboxes in the Add and Drop dialog boxes. -ex, -en,

    -ef, -es, and -e0 options determine the compression method: eXtra,

    Normal, Fast, Super fast, and no compression. The default is "Normal".

    -s allows specification of a password. The password can be enclosed

    In quotes, For example, -s"Secret Password". Note that passwords are

    case-sensitive.

    -hs option allows hidden and system files To be included.

    filename.zip

    Specifies the name of the ZIP involved. Be sure To use the full



    HTH

    Ivan

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Ivan

    Nice to see you post, and a big thanks, ill email to report.

    A tip 'o the hat to my friend on the other side of the world, my thanks!
    Your day is starting so please make it a good one, as my day starts to finish.

    Well have a drink soon on the Email's, thank you

    Rdgs


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com