Is there a way to change xls file extention from xlsm to xls?

[pedie]

Thanks for looking in to this thread.
I need help. Is there a way to change xls file extention from xlsm to xls?
I have a code that does not work with xlsm so I need to change the extention of my excel file to xls.
eg: book12.xlsm to book12.xls


Thanks for helping!
Pedie


My another theard link:http://www.mrexcel.com/forum/showthread.php?t=485089

 

[JackDanIce]

Hi pedie,

I receive a file from a third party in the format of .xlsm which I open and then select save as and change the format to .xls, before running some code on a master file that opens this particular file but in an .xls format.

Since it comes in as an email, it's currently easier for me to manually save it down as an .xls file, but depending on your needs, you may need to adjust your macro to open it as is and then use save as?

I'm curious to see other's thoughts on this, hence also why replying but with something maybe not so useful to you - sorry!

Jack

 

[pedie]

Thank for inputting. I didn't even try it that way....y am i so foolish?

Lemmi try it out!

This thread is still open! thanks

 

[pedie]

Okay sorry it does not work for me...Maybe I am not doing it right way.
I click on options >> save as >> manually changed to book12.xls but it picked that as file name and not as extention.


Please input guys!

 

[Jon von der Heyden]

You need to speficfy the file format in the 'Save as type:' drop-down in the save as dialog. You should choose Excel 97-2003 Workbook

EDIT:
Beware though because the workbook may contain elements not compatible with 2003 and may therefore caause errors or unexpected results.

 

[pedie]

Jon, that worked well. Do i click on yes to the pop up that ask to re-calculate the formulas and....?

 

[JackDanIce]

Trial and error, try it out on clicking yes and see what happens and clicking no!

 

[pedie]

Okay. Thank you so much for your help!