Code creates new workbook-> code to automatically run a set code on that workbook

**cwalker6** · 05-20-2009, 06:14 PM

I have code that splits sheets into different workbooks. When those are created into new workbooks, I would like for them to sort automatically without me manually putting in the code. Does anyone know a code that I can put in with the original workbook, before I put in the second code for the splits?
Code 1 (makes new workBOOKS)

Please Login or Register  to view this content.

Code 2 (sorts new books into sheets)

Please Login or Register  to view this content.

Thanks in advance!

**broro183** · 05-20-2009, 08:00 PM

hi

I'm not sure I understand exactly what you want, if it is to sort the sheets alphabetically by their names, have a look at the below link for some example code: http://www.cpearson.com/excel/sortws.aspx
which I found along with other code using the below Google search:
http://www.google.co.uk/search?hl=en...meta=&aq=f&oq=

I have some questions & comments about your existing code which I have prefixed with "###".

Please Login or Register  to view this content.

hth
Rob

Code creates new workbook-> code to automatically run a set code on that workbook

LinkBack

Thread Tools

Rate This Thread

Display

Code creates new workbook-> code to automatically run a set code on that workbook

Re: Code creates new workbook-> code to automatically run a set code on that workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions