+ Reply to Thread
Results 1 to 2 of 2

Bulk convert XLSX to XLTX

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    Calgary, Canada
    MS-Off Ver
    365
    Posts
    1

    Question Bulk convert XLSX to XLTX

    Hoping someone here might have a solution:

    I have a few hundred XLSX files that I need to convert to XLTX (template format). I'm looking for a way to do so in bulk (and already found out it isn't as simple as changing the file extension) as having to do it individually will be....painful.

    Can anyone provide a solution?

    Thanks in advance!

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013
    Posts
    393

    Re: Bulk convert XLSX to XLTX

    Put this code into a new Workbook and run it;

    It'll ask you for a folder and then look for all XLSX files in that folder, it'll open then and save them as XLTX.

    Please note the comment about removing the original XLSX file if you don't need it.

    Please use caution when using this as you won't be able to recover any lost documents.

    I'd suggest running it on backups of the original files till you're 100% sure of what you want.

    Please Login or Register  to view this content.

+ 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. bulk convert formula to value
    By frankday in forum Excel General
    Replies: 3
    Last Post: 10-05-2018, 06:26 PM
  2. Replies: 6
    Last Post: 08-11-2018, 06:02 PM
  3. Help with code to convert xls to xlsx and continue with xlsx file
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 11:47 AM
  4. how to convert .xlsx to .csv
    By Nehrav in forum Excel General
    Replies: 4
    Last Post: 11-04-2013, 07:24 AM
  5. [SOLVED] Won't convert xlsx to pdf well
    By sockerplaya37 in forum Excel General
    Replies: 2
    Last Post: 06-23-2013, 10:17 PM
  6. Bulk convert numbers to text
    By twizzler3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2011, 04:36 AM
  7. bulk convert strange file format in multiple folders.
    By freud1 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-03-2009, 11:01 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