Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Setup when saving a worksheet as a web page | Excel Discussion (Misc queries) | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
Update Botton | Excel Discussion (Misc queries) | |||
Excel saving as web page and scaling the print out to fit one page | Excel Discussion (Misc queries) | |||
Save Botton | Excel Worksheet Functions |