[RESOLVED] How to close and save an excel file using VBA

Hi Guys,

can anyone help in saving and closing the excel File using a VBA code? and also is it posible to disable the minimize restore and close buttons of the excel workbook?

Code:

---

activeworkbook.save
activeworkbook.close

---

though generally it is safer to specify the workbook by name, also if you want to close excel

Code:

---

workbooks("myworkbook.xls").close
application.quit

---

robdog may have some code to disable the red X, search in his posts at top of forum