quickest way to change multiple xlsm files to xlsx files

I'm assuming this is what you are looking for...

Quickest way to convert

 To convert a single XLSM file,  “C:\in\input.XLSM” to an Excel (XLSX) file located in the  “C:\Out\” folder, the following syntax would be used:

  ConvertXLS.EXE /S"C:\in\input.XLSM"  /T "C:\Out\output.XLSX" /C-4143  /F52 /M2 /V


To convert a whole folder (and subfolders) of XLSM files located in  C:\in\*.XLSM  to XLSX files to be placed within c:\Out\ folder, the following syntax would be used:

  ConvertXLS.EXE /S"C:\in\*.XLSM"  /T "C:\out\*.XLSX" /C-4143  /F52 /M2 /R /V

Saurabh...

In additional their is a beautiful article by dlmille on the site itself which you can find out here..
Article

Saurabh..

Is this a batch file or where do I run this code. I ran it as a batch file but did not work.

You can download the excel file from here..

https://www.experts-exchange.com/questions/27323432/Delete-all-VBA-in-all-workbooks-in-a-folder.html

Also in order to run you need to have folder created with output to do what you are looking for..

Saurabh...

It does not work. It did change the .xlsm to .xlsx but I can not open the files after wards. Any help with this. Thank you.

Joy,

Here is the macro file from article you can run this file and follow the instructions and it will do what you are looking for..

Can you run this one and verify..

Saurabh...
loopAndConvert.xlsm

No this did not work at all. It coverts from .xlsx to .xlsm when I want to go from .xlsm to .xlsx. Thank you.

Joy,

I just converted two files myself from xlsm to xlsx using the above file i don't see any challenge their..here is the screenshot of what i select.. Again i selected the folder in which i need to do this conversion...


Post that i don't ran into any problems for the same..

Saurabh...

The file you gave me is the different than your screen shot. I will up load an image of my screen shot and as you will see it coverts .xlsx file to .xlsm file. All the file I have are .xlsm file and I need to covert them to xlsx file. sorry about this.
Thank you for all Doc1.docxyour help.

Jody,

The file that i gave to you to loop and convert Here is the same file which i used and the screenshot of.

Now what essentially through screenshot i wanted to share the logic for it..which i used and it worked seamlessly..

Saurabh...

Can you give me the link again to the loop and convert file that you used. I want to see if I can get this done as I have a lot off .xlsm file to open and save as .xlsx files. Thank you for all your help with this problem.