what is the wrong?
 

could you please advice me what is the wrong with the save as formola,
(Filename:="\\appserver\users\SUPPLIERS\FILE 02-\")
=SAVE.AS('[test.xls]Cosmetic 02-2009'!$A$1)
=RETURN()
1*as the files saved in deverant foldar , I need it all the time to be in
the folder
\\appserver\users\SUPPLIERS\FILE 02-\
2- I need to cancel the formola buttun after saving .??