Navigation

    精算后花园

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Kea_Zhang
    K
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    Kea_Zhang

    @Kea_Zhang

    0
    Reputation
    1
    Posts
    1
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    Kea_Zhang Follow

    Best posts made by Kea_Zhang

    This user hasn't posted anything yet.

    Latest posts made by Kea_Zhang

    • 提问:如何调用Shell语句解压.gz文件

      求助:需求是使用Shell语句调用winzip64.exe解压.gz文件。原始代码如下:

      Sub GZ_Extractor()
      Dim File As Variant
      Dim shellStr as String
      File = Dir("C:\Users\Folder\")
      while (file<>"")
           If InStr(1,file,".gz")>0 then
               shellStr = "C:\Program Files\Winzip\winzip64.exe -e C:\Users\Folder\" & file &"C:\Users\Folder\"
               Call Shell(shellStr, vbHide)
          End If
          file = Dir
      Wend
      End Sub
      

      运行无报错,但是"C:\Users\Folder"内的.gz文件并没有解压成功。
      请问这段代码为何无法解压?若有更好的思路欢迎交流~

      posted in Excel & VBA
      K
      Kea_Zhang