Hi All
I have this code which splits the multiple excel worksheets into individual excel file and saves it all in same location as active workbook.
Each Excel file is named after the sheet name.
I basically have 5 sheets say MODELA, MODELB, MODELC, MODELD,and MODELE.
What i want is,to save all this 5 excel files in 5 difrnt location which i will specify in code and not as done here in activeworkbook.
Any help would considerably reduce the time of my teamPlease Login or Register to view this content.
Thanks in advance
Bookmarks