Press Alt+F11 coding window will open there you will find sheet1,sheet2,sheet3 and this workbook as shown in the screenshot. double click on thisworkbook and paste the code there.
let us know if u require anything else happy to help. Note: in place of your path give \ at the end of the path. i.e. C:\Documents and Settings\ >________________________________ >From: Aamir Shahzad <aamirshahza...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Sunday, 23 October 2011 4:28 PM >Subject: Re: $$Excel-Macros$$ HELP REQUIRED > > >Can you please brief how to use & apply the codes in excel. > > >Aamir Shahzad > > > >On Fri, Oct 21, 2011 at 1:30 AM, hanumant shinde <arsfan2...@yahoo.co.in> >wrote: > >yes very much possible with hardly 5 lines of code (if u want it for time >being). >> >>send us the file or use the below code in the file if u can. >> >> >>Sub Macro1() >> >>ChDir "Your Path" >> >>Dim wrksht As Worksheet >> >> For Each wrksht In ThisWorkbook.Worksheets >> wrksht.Select >> wrksht.Copy >> ActiveWorkbook.SaveAs Filename:= "your pah" & wrksht.Name & ".xlsx" >> ActiveWindow.Close >> Next >> >>End Sub >> >> >> >> >> >>>________________________________ >>>From: vijayajith VA <vijayajith...@gmail.com> >>>To: excel-macros@googlegroups.com >>>Sent: Thursday, 20 October 2011 9:19 PM >>>Subject: $$Excel-Macros$$ HELP REQUIRED >>> >>> >>> >>>HI, >>> >>> >>> >>> >>>I have 10 to 15 tabs with different name in one excelworkbook.i need each >>>tab separtely save it in one folder with that name.Is this possible using >>>macros >>> >>> >>>Thanks >>>vijay -- >>>---------------------------------------------------------------------------------- >>>Some important links for excel users: >>>1. Follow us on TWITTER for tips tricks and links : >>>http://twitter.com/exceldailytip >>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>3. Excel tutorials at http://www.excel-macros.blogspot.com >>>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>>To post to this group, send email to excel-macros@googlegroups.com >>> >>><><><><><><><><><><><><><><><><><><><><><><> >>>Like our page on facebook , Just follow below link >>>http://www.facebook.com/discussexcel >>> >>> >>> >>-- >>---------------------------------------------------------------------------------- >>Some important links for excel users: >>1. Follow us on TWITTER for tips tricks and links : >>http://twitter.com/exceldailytip >>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>3. Excel tutorials at http://www.excel-macros.blogspot.com >>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>To post to this group, send email to excel-macros@googlegroups.com >> >><><><><><><><><><><><><><><><><><><><><><><> >>Like our page on facebook , Just follow below link >>http://www.facebook.com/discussexcel >> >-- >---------------------------------------------------------------------------------- >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel