+ Reply to Thread
Results 1 to 2 of 2

Unzip all files in a specific folder and move CSV files to a different specificed folder

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unzip all files in a specific folder and move CSV files to a different specificed folder

    Hi all! I have referenced this site for help on multiple occasions, but this is my first post. I hope I am following all correct protocol!

    I am trying to use vba to loop through several zipped files within a specific folder, unzip each, and move (or copy) the CSV to a separate zipped folder. I would like to re-name the CSV file to the name of the zipped file, but as a CSVxl format.

    I have looked at several posts and tried what appears to be similar code. However, I just cannot get it to work... :/ Any help would be greatly appreciated!

    Thank you!
    Brooke

  2. #2
    Registered User
    Join Date
    01-25-2019
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    1

    Re: Unzip all files in a specific folder and move CSV files to a different specificed fold

    I have the same challenge. Being a novice at VBA I am struggling to get the multiple file selection right

+ 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. [SOLVED] macro to move all files from one folder to another files
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2013, 07:37 PM
  2. [SOLVED] Move Files from Folder to Folder
    By THE_RAMONES in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 04:25 PM
  3. Replies: 1
    Last Post: 01-24-2006, 11:35 AM
  4. Replies: 1
    Last Post: 01-24-2006, 11:00 AM
  5. Replies: 1
    Last Post: 01-24-2006, 12:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1