+ Reply to Thread
Results 1 to 2 of 2

Convert multiple excel files into csv file

  1. #1
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Convert multiple excel files into csv file

    I need a macro to convert multiple XLS to CSV Format in a specific folder to the downloads folder at in one click.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Convert multiple excel files into csv file

    Here's a link to my blog where we've tackled this in the past.

    Workbooks to CSVs

    I'm confident this old macro will get you 90% of the way there, just need to tweak it to your specific needs.

    Cheers.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Convert Multiple text files to excel files
    By shanmugapriya.a in forum Excel General
    Replies: 3
    Last Post: 07-07-2015, 10:39 AM
  2. Convert multiple text files to be excel files
    By PStump in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2014, 05:44 PM
  3. [SOLVED] Macro to copy selected columns and convert the file into multiple csvmsdos files
    By tanay.vinod in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2014, 03:52 AM
  4. Need to convert a txt files to excel file.
    By vinodhec in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 04:28 AM
  5. How Do You Convert PDF Files Into An Excel File?
    By Richie77777 in forum Excel General
    Replies: 1
    Last Post: 04-23-2013, 04:33 PM
  6. Apply macro to multiple CSV files and then convert to XLS or TXT file,
    By asok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2012, 10:13 AM
  7. Replies: 2
    Last Post: 12-07-2008, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1