+ Reply to Thread
Results 1 to 16 of 16

VBA to Auto Zip the Folder or Files

  1. 10-06-2014, 12:39 PM #1
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    VBA to Auto Zip the Folder or Files

    Hello All,

    Could someone help me in Auto Zipping the Folders or Files from a specific location.

    I need a VBA code which will automatically zip the folders.

    Thanks in Advance.

    Regards
    Vinay
    Reply With QuoteRegister To Reply
  2. 10-06-2014, 12:40 PM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: VBA to Auto Zip the Folder or Files

    http://www.rondebruin.nl/win/section7.htm
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 10-06-2014, 01:29 PM #3
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    That was good but i need the VBA to Auto the Files or Folder as specified below.

    1. In a spread sheet "Sheet1" i have different input locations from "A1 to A25"
    2. Now when i run the VBA code it should Auto zip the files/Folders which are listed in "A1 to A25"

    Kindly help me on this.
    Reply With QuoteRegister To Reply
  4. 10-06-2014, 09:58 PM #4
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    can someone help me on this....
    Reply With QuoteRegister To Reply
  5. 10-07-2014, 12:58 AM #5
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    Hello All,

    I have a code which will Zip the Folders but this is limited to one folder.

    Whereas i have multiple folders which i cannot manually post it in the code.
    So i have attached a Workbook which has Source File location and Destination locations. Can u please make the necessary cahnges to this code, so that it will run for all the files.

    Also the output Zip name should be the source Folder name but when i execute the code it creates as .zip only.

    Kindly help me on this.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 10-07-2014, 01:46 AM #6
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    Please help me on this.
    Reply With QuoteRegister To Reply
  7. 10-07-2014, 01:55 AM #7
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA to Auto Zip the Folder or Files

    ok give me some time i will look it out this...
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
    Reply With QuoteRegister To Reply
  8. 10-07-2014, 02:00 AM #8
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA to Auto Zip the Folder or Files

    vinay that locations which is there in column A that all folder name only right
    Reply With QuoteRegister To Reply
  9. 10-07-2014, 02:05 AM #9
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    Yes those are Folder Names
    Reply With QuoteRegister To Reply
  10. 10-07-2014, 02:31 AM #10
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    Do u have the chance to look into this.
    Reply With QuoteRegister To Reply
  11. 10-07-2014, 02:41 AM #11
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA to Auto Zip the Folder or Files

    try this below code 
    Please Login or Register  to view this content.
    open the file and change the 2nd row source & Destination Path and try it & let me know
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 10-07-2014, 02:56 AM #12
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    Great!!!

    Its working.

    Thanks for the Help...
    Reply With QuoteRegister To Reply
  13. 10-07-2014, 03:32 AM #13
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA to Auto Zip the Folder or Files

    Quote Originally Posted by mvinay View Post
    Great!!!

    Its working.

    Thanks for the Help...
    Glad to Help
    Please Mark this thread as SOLVED & Please Click on *Add Reputation to say thanks
    Reply With QuoteRegister To Reply
  14. 10-28-2014, 04:08 AM #14
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    oops!!!

    can it possible to start Auto zip all the listed files once i click it?

    It would be great if this is done.

    Thanks in advance
    Reply With QuoteRegister To Reply
  15. 10-28-2014, 04:40 AM #15
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA to Auto Zip the Folder or Files

    Its Auto Zip only right ?
    Reply With QuoteRegister To Reply
  16. 10-28-2014, 05:20 AM #16
    mvinay
    mvinay is offline
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: VBA to Auto Zip the Folder or Files

    yes its for Auto Zip only.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unzip all files in a specific folder and move CSV files to a different specificed folder
    By bfaaborg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  2. Auto import data from all text files in a folder (VBA)
    By anto80mtl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2013, 12:34 PM
  3. Auto-Populating from all files in a designated folder
    By taketwo in forum Excel General
    Replies: 3
    Last Post: 10-22-2009, 12:13 PM
  4. auto open excel files in the folder
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2009, 02:19 AM
  5. auto open the excel files in the folder
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2008, 04:16 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1