View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rajaiy rajaiy is offline
external usenet poster
 
Posts: 8
Default save as , and dellete botton after saving one page.

Dear All

I have one problem with my data sheets, I have along list of requests from
my suppliers, each line have one defirant request screen, in the request
screnn I have 3 bootms, 1- copy, 2- email, 3- save.
as when I have make new screen, and add all the information of the request
and save it, with the bottom (save) the function save it as the last line no
( ex no 120 ) in the requests list, but if I have to make any change in the
same recest screen ( ex no 120) , and I have already new line with the no
121, if i press the bottom save in the file no 120, it withh save it as 121,
and it is problem for me, how I could deleet the bottom save , or to make it
not to svae the edit request screen as for the last line as the new request
secrrn,
my next broplam is how i could make the save bottom to be in spicial folder
and no in my document as it is now.
please see the function of the save botton.

Filename:="\\appserver\users\m\FILE 02-\"
=SAVE.AS('[test.xls]Cosmetic 02-2009'!$A$1)
= cellect ()
= clear()
=RETURN()

thanks for your help.