I am trying to automatically close excel after I do a save as event macro. The problem that I am encountering has to do with the fact that the save as feature is saving the worksheet as a .txt file. I can't seem to get the workbooksObject.close to work. Any suggestions

Ryan