If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AUTOMATIC FILE SAVING
Subject: AUTOMATIC FILE SAVING 7/6/2009 11:18 PM PST
By: pravin In: microsoft.public.excel.newusers 1.Thanks for the prompt reply and regret the non clarity in my question. 2.I have a template for making quotations.Each customer has a name code like - BUZ,CDE,COD , in cell C7 3.Each quotation has a serial number eg. 178 in cell F7 4.When I click a "Save" button, with an assigned micro, the quotation worksheet must be saved under the "QUOTATIONS" folder in the specific customer's sub-folder,arranged in serial order of the quotation number. eg. K:QUOTATIONS\BUZ\178, K:QUOTATIONS\BUZ\179,K:QUOTATIONS\BUZ\180 6.How can I create a micro which will do the above for me. Thanks -- excelforautomatinginvoicing |
Thread Tools | |
Display Modes | |
|
|