Executing program with vba

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cavemonkey
    New Member
    • May 2007
    • 1

    #1

    Executing program with vba

    Hi

    Can anyone advise me as to how to execute a program (for my case its winzip) and extract whatever that is compressed in it out into a folder?

    Right now I'm only able to open the winzip application and my winzip folder but i don't know how to make it extract the data after my winzip folder is open

    Please advise. Thank you
  • danp129
    Recognized Expert Contributor
    • Jul 2006
    • 323

    #2
    I use version 7 of winzip... older than dirt... Anyhow I don't see a reference I can add for it. You can either try using the command line add-on for it, a wrapper (if you want to translate it) or using a different zip program that exposes it's COM...

    Comment

    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429

      #3
      Yes, if you want to stick with WinZip then the Command-Line Interface is probably a good way to go. I believe it's free, too (the CLI, not WinZip).

      Comment

      Working...