+ Reply to Thread
Results 1 to 2 of 2

Error while trying to unzip

  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 ?

    Please Login or Register  to view this content.
    Last edited by sabrefan1970; 11-14-2013 at 09:21 AM.

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

    Re: Error while trying to unzip

    Runtime 91 error --- be absolutely sure your pathnames are correct. I must have had a wayward space since after deleting the line and retyping it the code didn't throw the error, but I still didn't get any unzipped files.

    The files appeared after I changed the security settings for the output folder to FULL CONTROL for everybody -- system, administrators,groups and single users. It was read only for system and administrators. How this happened I don't know as I created the folder using the "NEW" function in Windows Explorer and never explicitly went and changed any security settings until desperation caused grasping at straws.

+ Reply to Thread

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. [SOLVED] 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