[EricH]

I hate to ask this... but are you sure the macro's workbook isn't trying to save itself as a .xlsx? Because that would cause a lot of problems. I can't tell what the active workbook happens to be--there's no call within the subroutine posted to select and activate a particular workbook (though, granted, that could easily be being handled elsewhere).

Try specifically setting which workbook needs to be saved (just make sure it's always in the same spot in the list of workbooks). I had some really screwy issues in one of my macros a while back and ended up telling the macro very specifically that it was to look in THIS sheet or THAT sheet when it was looking for whatever I was having it look for, rather than selecting the sheet and looking in it. Problem went away as soon as I did that.


Short version: Try telling Excel specifically which workbook is the active workbook that needs to be saved.