Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I reduce repetative code
i have set up a userform with OptionButton for all the weeks of the year to
save data too, with a command Button with If OptionButton1=true then -and code- Instead of having to repeat the same steps over and over again eg: open new workbook / name new workbook / copy data to new workbook /save workbook / close workbook. My question: Can I set up a variable for week Number and associate that into the file name, therby saveing approx 40 lines of code for each week no. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I reduce repetative code
Repetative posting is as bad a practice as repetative code, have a look in
your other thread. Mike "leerem" wrote: i have set up a userform with OptionButton for all the weeks of the year to save data too, with a command Button with If OptionButton1=true then -and code- Instead of having to repeat the same steps over and over again eg: open new workbook / name new workbook / copy data to new workbook /save workbook / close workbook. My question: Can I set up a variable for week Number and associate that into the file name, therby saveing approx 40 lines of code for each week no. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I reduce repetative code | Excel Discussion (Misc queries) | |||
how to reduce execution time of my code? | Excel Programming | |||
Any way to reduce/combine in this code? | Excel Programming | |||
Reduce code | Excel Discussion (Misc queries) | |||
Reduce file size by removing comments from code? | Excel Programming |