Results 1 to 2 of 2

Error while trying to unzip

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    ROCHESTER, NY
    MS-Off Ver
    Excel 2007
    Posts
    21

    Error while trying to unzip

    First, I have tried the Ron de Bruin method with no luck. Same Runtime 91 error at the "CopyHere" line

    I get a runtime error 91 "Object variable or With block variable not set " at the

    ' Set oSrc = ... line

    I have tried every combination of double parenthesis, single parenthesis, "Items" , "Items.item", "Item" and so on that I can think
    of.

    If I omit the .Item reference no runtime error happens, but it doesn't unzip anything either.

    Any Ideas ?

    Sub Macro1()
    
    ' Macro1 Macro
       
       Dim oShell As Object
       Dim oFloder As Object
       Dim oSrc As Object
       
       Dim SRC As Variant
       Dim DEST As Variant
       
       SRC = "c:\TestZip1\SourceZipFolder.zip"
       DEST = "c:\TestZip2\"
       
        Set oShell = CreateObject("Shell.Application")
        Set oFolder = oShell.Namespace((DEST))
        Set oSrc = oShell.Namespace((SRC)).Item
        oFolder.CopyHere oSrc
         
         End Sub
    Last edited by sabrefan1970; 11-14-2013 at 09:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. zip unzip .xlsx file error
    By IT Researcher in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 08:35 AM
  2. Need macro to Zip/Unzip
    By Vinoth Kanna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 03:41 AM
  3. [SOLVED] Unzip file through VBA
    By amitdi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-15-2012, 09:36 PM
  4. unzip
    By aaabc0555 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 04:45 PM
  5. Unzip - multiple zips
    By JohnUK in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-28-2006, 05:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1