Hi Santhos.
Place a folder in desktop.
change..according to week..
Sub Macro1()
ChDir "C:\Documents and Settings\user\Desktop\week 46"
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
ActiveWorkbook.SaveAs Filename:="Account Reciveab
Hi santhosa,
Press Alt +11
Use below --code..
Change accordingly..
Sub Macro1()
ChDir "Your Path"
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
ActiveWorkbook.SaveAs Filename:= "your path" & wrksht.Name & ".xlsx"
ActiveWindow.C
Hi Friends,
Need your help on the below. Please find atatched sample report.
1) Split the tabs into differnt file.
2) Give file name as "Account Reciveable - Tab name" and save it in a
specific folder (Week 46).
Let me lnow if you are unclear on this.
Regards,
Santhosh
--
Join official Faceb
