+ Reply to Thread
Results 1 to 2 of 2

Batch update of many XLS files to XLSX format?

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Batch update of many XLS files to XLSX format?

    Hi folks,

    Please can anyone advise me how best to 'update' very many old XLS (version4) excel files to XLSX format (without manually opening each one, and re-saving it in the xlsx format!)?

    My old files are now being used in a school environment in which the default 'trust' policies to not allow such old files to run (or at least, not to be edited). That's why I need to change them all.
    I've manually changed a couple and they then work perfectly well, but I've hundreds (distributed throughout many different directories) that I'd like to change 'all at once'.

    I'd appreciate any advice, thanks,

    UKMathsTeacher

  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,917

    Re: Batch update of many XLS files to XLSX format?

    I don't believe there is any simple (meaning short/quick) way to do this, because the file format gets changed - most options I have seen seem to suggest VBA (coding). A quick google search on "batch process xls to xlsx" turned up a bunch of likely looking hits
    https://www.google.com/?gws_rd=ssl#q...ls%20to%20xlsx
    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

+ 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] .CSV to .XLSX Automatic Batch Conversion
    By prosemur in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 08-27-2021, 11:35 PM
  2. Replies: 0
    Last Post: 01-14-2016, 03:22 PM
  3. [SOLVED] Batch Convert XLSX to XLS
    By Ernching in forum Excel General
    Replies: 3
    Last Post: 08-22-2015, 11:46 AM
  4. Vba code to convert xlsx files in xls files 2003 format
    By clixo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2014, 01:50 PM
  5. Batch .iqy to xlsx conversion
    By nickfan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 09:32 AM
  6. Merge Data from different .xlsx files & different sheet to a new .xlsx
    By QcSylvanio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2012, 01:11 PM
  7. How to add the columns data of several xlsx files of a folder in another xlsx file
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-25-2012, 04:29 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