LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default directory structure in VBA form.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File directory structure reorg strebor44 Links and Linking in Excel 1 July 2nd 08 08:50 AM
Creating Directory Structure from Cell Value [email protected] Excel Worksheet Functions 5 December 7th 07 09:33 PM
Create Directory Structure from Cell Value. [email protected] Excel Discussion (Misc queries) 0 December 3rd 07 09:02 PM
Make directory structure variable Pepestru Excel Programming 1 February 23rd 07 01:55 PM
How to write directory structure to excel file suyog_linux Excel Programming 8 November 28th 06 09:00 PM


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"