Dear All
Excel work book contains numerous named work sheets.I want to globally convert these work sheets into individual work book and saved individually
Any help I shall appreciated
.................................................................................................... ..............................................
Lets me explain more about this,I'm using information from accounting system, I copy and paste to excel to form new work book which has numerous sheet,i.e. Sheet1,sheet2,........to sheet20 each one has various information.
Now i need to save each sheet seperately from original work book.For the moment I'm using move and copy to a new work book then I save wherever i want to save
Now the problem is it takes more time and I'm supposed to open so many new work book
So can I get your help,to do this job easily and less time consuming
Thank you
Wahiba

Hi,

Try this link

http://www.rondebruin.nl/copy6.htm

VBA Noob

__________________
_________________________________________


Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters

Please remember to wrap code.

Forum Rules

Please add to your signature if you found this link helpful. Excel links !!!