I really know nothing of VB, so I've just been going off of what code I can find in google searches. What I want to do is create a macro to save a workbook in different locations and different formats. Here's the code I'm using at the moment.

Please Login or Register  to view this content.
The problem is that the .xlsm files give me an error message like "The extension doesn't match the file format." Only the active page needs to be saved as a .csv, and that is working fine. Thanks in advance.