Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ------------------------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|