Adjusting Macro to save out as a certain file type

Was trying to help out a co-worker with adjusting a macro but I'm at a loss.

The macro below sorts through POs and creates and individual file for each PO to be sent to the vendor. The problem we are having is when the files get sent over, the vendors are on excel 2003 and can't open the files. My co-worker just got upgraded to 2010 which is when the problem started. Her default settings have been adjusted to save out files as a 97-2003 workbook and you can see the macro names the files .xls. They look fine after they are saved, but when you try to open them, it says the "workbook is in a different format than the extension" and if you say its fine, opens it as a .xlsx file.

Any thoughts?

Please Login or Register  to view this content.

I think I may have stumbled across a solution I had previously missed. Need to add a section after .xls to specify the correct file format and see if that fixes it.