Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the idea. Yeah, I could do that. In fact, on several
applications, I have. If a workbook is open, it uses that as the input. If no other workbook is open, it asks the user to select their input workbook. Maybe it's just my concept of change in this area that's out of whack. This whole thing started almost 10 months ago, and I had the first demo/cut done pretty quickly... Think maybe it's just my head that's gotten too attached to the existing form. But anyway, after the sheet with the input parameters is selected, the rest of the coding change is easy... the code uses 5 range variables which define where the inputs are. It's written so that one set of inputs can kick of multiple loops and in the end compare the whole bunch, if that's what the user wants. But anyway, changing the input is easy... just change the assignments on the controlling range variables. Thanks for the continued suggestion. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File directory structure reorg | Links and Linking in Excel | |||
Creating Directory Structure from Cell Value | Excel Worksheet Functions | |||
Create Directory Structure from Cell Value. | Excel Discussion (Misc queries) | |||
Make directory structure variable | Excel Programming | |||
How to write directory structure to excel file | Excel Programming |