+ Reply to Thread
Results 1 to 5 of 5

Batch files using save as

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Batch files using save as

    Hello,
    I am wondering if it is possible to run a batch command in any way that I could have lets say 20 xlsx files in a folder and have them auto opened and re-saved as a csv file into another folder? Is this possible?
    Thank you for any help in this matter

    DeZineZone

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Batch files using save as

    Hi and welcome to the forum

    This would be a VBA process, so I will move this thread to that forum for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Batch files using save as

    Thank you for moving this to the correct forum

  4. #4
    Forum Contributor
    Join Date
    04-03-2012
    Location
    Washington State
    MS-Off Ver
    Excel 365
    Posts
    340

    Re: Batch files using save as

    Here is a vbscript file I have used for a very similar thing... this will save all files in the "XLSX" folder and save them as .csv to the "CSV" folder. Change directories as you need, paste this code in a text file and save as "anything.vbs" and run. If you want to delete the .xlsx files after, take off the apostrophe in front of "file.Delete".

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-02-2014
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Batch files using save as

    Thank you very much. I will give this a try in the morning

+ 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. Replies: 1
    Last Post: 11-12-2013, 03:44 PM
  2. [SOLVED] Batch job. Open a lot of excel files, delete the same values from each, save, then close
    By greendale in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-06-2013, 03:31 PM
  3. Batch Files
    By nickysquawkes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-02-2006, 04:20 PM
  4. VB and Batch files
    By JT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2005, 04:05 PM
  5. Batch conversion of XP files to 97 files
    By AG in forum Excel General
    Replies: 2
    Last Post: 10-02-2005, 10:05 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