quickest way to change multiple xlsm files to xlsx files

I have 150 to 160 excel files that were saved as .xlsm files but need to change them to .xlsx files. Is there a way I can do this all at once or do I have to open each file  and save as .xlsx. Hope there is a quick way to do this. Thank you.
jodyreidIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
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...
Saurabh Singh TeotiaCommented:
In additional their is a beautiful article by dlmille on the site itself which you can find out here..
Article

Saurabh..
jodyreidIT ManagerAuthor Commented:
Is this a batch file or where do I run this code. I ran it as a batch file but did not work.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Saurabh Singh TeotiaCommented:
You can download the excel file from here..

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27323432.html

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

Saurabh...
jodyreidIT ManagerAuthor Commented:
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.
Saurabh Singh TeotiaCommented:
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
jodyreidIT ManagerAuthor Commented:
No this did not work at all. It coverts from .xlsx to .xlsm when I want to go from .xlsm to .xlsx. Thank you.
Saurabh Singh TeotiaCommented:
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...

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

Saurabh...
jodyreidIT ManagerAuthor Commented:
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.
Saurabh Singh TeotiaCommented:
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...
jodyreidIT ManagerAuthor Commented:
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.
Saurabh Singh TeotiaCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.