Excel VB sub
 

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
------------------------------------------------

Excel VB sub
 

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



"zzjones" wrote in
message ...
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
------------------------------------------------