CA Ramsai N (Fresher) 04 September 2013
2. press alt+F11>> Insert >> Module
3. Paste following text
MyPath = ThisWorkbook.Path
For Each sht In ThisWorkbook.Sheets
Filename:=MyPath & "\" & sht.Name & ".xls"
6. Pre caution:: it would be better to keep that sheet in separate folder before splitting into
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more