P
pravin
Subject: RE: 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
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