Excel VB sub

[zzjones]

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



------------------------------------------------




------------------------------------------------

 

[Chip Pearson]

Bill,

If you mean that you want to use VBA to write a new procedure in
the workbook, see www.cpearson.com/excel/vbe.htm for sample code
showing how to use VBA to create VBA code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)