Hi All; I wrote a lengthly Excel VB program that takes a large amt of
mixed text data (report.txt) and separates it into several worksheets
(product1)(product2)and (product3) + (summary)then sorts and counts
monthly call center data and charts the summary data. It also saves the
workbook as "report_current_month.xls".

This thing reduces my monthly labor from 5-7 hours to abt 30 seconds.

My question is -
I want to insert a new sub into the new workbook so it will be active
when I start it. I assigned ctrl+z and it works great if I have the
initial sub active. I want to save the new workbook and use this sub.
when needed. Is there a way to do this?

thanks -bill



------------------------------------------------
Message posted from the Excel Tip Forum at http://www.ExcelTip.com/forum/

-- View and post usenet messages directly from http://www.ExcelTip.com
-- Hundreds of free MS Excel tips, tricks and solutions
------------------------------------------------