save and close excel sheet

How can i do the above.

in applescript, when i try the normal, save documen or something it doesn;t want to work.

Any ideas?

Try:

tell application “Microsoft Excel”

Save ActiveWorkbook In “YourFileName.xls” Password “” WriteReservedPassword “” without ReadOnlyRecommended and CreateBackup

Close ActiveWindow

end tell

Mark