+ Reply to Thread
Results 1 to 5 of 5

Split workbook 400 sheets into separate .xlsx files, but need to be .csv

  1. #1
    Registered User
    Join Date
    10-12-2016
    Location
    London, England
    MS-Off Ver
    MIcrosoft Excel for Mac Version 16.33
    Posts
    17

    Split workbook 400 sheets into separate .xlsx files, but need to be .csv

    Hello!

    I recently split a workbook with 400 sheets into 400 separate files. They are .xlsx files but I need them as .csv.

    Are there any ways of converting 400 .xlsx files to .csv, or splitting a workbook of 400 sheets into separate .csv files?

    I would like them to be all in one folder together if possible

    I am using mac.

    Thanks.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,891

    Re: Split workbook 400 sheets into separate .xlsx files, but need to be .csv

    Administrative note

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,403

    Re: Split workbook 400 sheets into separate .xlsx files, but need to be .csv

    https://www.youtube.com/watch?v=Pzk1Iq5jSxo

  4. #4
    Registered User
    Join Date
    10-12-2016
    Location
    London, England
    MS-Off Ver
    MIcrosoft Excel for Mac Version 16.33
    Posts
    17

    Re: Split workbook 400 sheets into separate .xlsx files, but need to be .csv

    Quote Originally Posted by alansidman View Post
    Unfortunately when I run this I get:

    "Run-time error '91': Object variable or With block variable not set"

    when I click debug it highlights:
    ChooseFolder.Title = "Select Target Path"

    in the video it pops up and he selects the target path but seems to not work for me, maybe because I'm using Excel for mac?

    Thanks

  5. #5
    Registered User
    Join Date
    10-12-2016
    Location
    London, England
    MS-Off Ver
    MIcrosoft Excel for Mac Version 16.33
    Posts
    17

    Re: Split workbook 400 sheets into separate .xlsx files, but need to be .csv

    I tried the VBA code on Windows and it worked! So the problem was the mac.

    Thanks for your help, problem solved.

+ 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] Save workbook as two separate formats (CSV and XLSX) and leave XLSX open
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2019, 07:20 PM
  2. Split XLSX Workbook into Separate CSV Files
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2017, 04:36 PM
  3. Replies: 0
    Last Post: 01-14-2016, 03:22 PM
  4. Macro to Split Workbook into separate Files
    By hkn4 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2012, 11:26 AM
  5. workbook sheets into separate files
    By markx in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] workbook sheets into separate files
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  7. [SOLVED] workbook sheets into separate files
    By markx in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM

Tags for this Thread

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