Monthly Archives: April 2015

Split excel worksheets to individual files

If we have about many sheets in excel, and save all the sheets as their own files will definitely was not about to do this by hand. it take a take time!. I found a good tips from the internet, to solve this problem,in which using the macro!.

Here the code:

Sub CreateNewWBS()
 Dim wbThis As Workbook
 Dim wbNew As Workbook
 Dim ws As Worksheet
 Dim strFilename As String
 Set wbThis = ThisWorkbook
 For Each ws In wbThis.Worksheets
 strFilename = wbThis.Path & "/" & ws.Name
 Set wbNew = ActiveWorkbook
 wbNew.SaveAs strFilename
 Next ws
End Sub



Remove the last part of every line in notepad++

If we have the lines:

and we want final lines become like this:

we can applied notepad++ to do it. The solution as follow:

1) Using notepad++ and go to the search. Please used the regular expression as search mode

2) search


index\ means search for word; .* means everything else; $ means the end of line.

3) then replace with


4) That should find everything after (and including) index.php, and replace it with just index.php.