Thread
:
Excel VB sub
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
------------------------------------------------
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson