VBA to save macro enabled workbook to regular workbook

[Jiptastic]

I want to have VBA that saves a Macro Enabled workbook into a regular workbook. It bugs and says "Run-time error '1004' this extension can not be used with the selected file type. If I change it to "xlsm" it works fine, but that's not what I want. Any help?

Please Login or Register  to view this content.

[jaslake]

Hi Jiptastic

You can try one of these...don't know where that extra backslash comes from

Please Login or Register  to view this content.

[HSV]

Don't forget the displayalerts.

Please Login or Register  to view this content.