Help on the use of SaveCopyAs command in Macro

[canguest]

Hello; I'm wirting a macro to create records in a formatted form for each row in a spreadsheet
Everything works ok; I can create as many forms as rows are populated with information.
The issue I'm encountering is that the SaveCopyAs command creates files in version 2003; so every time I open the new created files a dialogue box appears to validate the file is ok to open. I'm creating hundreds of records.
I need help with my command line to create files in the same version I'm working on 2013.
Can anybody please help with suggestion for a different approach?
Thanks so much for your help.

this is the saving script in my macro:
-----------------------------------

Please Login or Register  to view this content.

----------------------------------

[TMS]

You are giving the file a 2003 .xls extension. Try using 2007+ .xlsx extension.

[canguest]

You are giving the file a 2003 .xls extension. Try using 2007+ .xlsx extension.

If I use the .xlsx extension then the files created are useless unrecognized by excel; unreadable and excel doesn't open files
Macro runs with .xls extension.
Are there any other suggestions?
Thanks

[TMS]

What type of file is the original? If that is .xls, I think you should convert it to .xlsm.

[canguest]

What type of file is the original? If that is .xls, I think you should convert it to .xlsm.

The original file is .xlsm
All outputs should be saved without macro as .xlsx
I want to keep the original unchanged so I can continue running with all target sources.

[TMS]

My understanding is that SaveCopyAs does exactly that ... saves a copy of the workbook with its existing format. If you are trying to change the file extension, that is probably why you get the warning message when you next open the copy.

I think you would need to use SaveCopyAs to make an exact copy, then open the copy and use SaveAs to change the file extension and format in order to remove the macros.