hicksi
Board Regular
- Joined
- Mar 5, 2012
- Messages
- 203
I have THREE different spreadsheets, all using some common UserForms and Modules. (actually, there's 6, but that's unimportant as the extra 3 are TEST versions with the same code but different data)
I have the Export script that's around in many places that will export all forms, classes and modules to text (so I can put them into Code Library). I have even extended this so it exports the FRX to text by rolling through the properties. THAT allows me to monitor when the positioning of the controls moves.
The three spreadsheets are controlled by both Conditional-Compile code in some forms (that restrict the frames and tabs in the View-Only copy of the form), and by Conditional-Compile code in the PROJECT of each.
It effectively allows me to define the code so that there is a FULL version, a VIEW version (containing only 30% if the forms) and another version that views the data from a different aspect (customers instead of products)
My problem is that I cannot figure out how to export the project details (ie the project conditional-compile parts) to text so I can load them to the Code Library.
I have the Export script that's around in many places that will export all forms, classes and modules to text (so I can put them into Code Library). I have even extended this so it exports the FRX to text by rolling through the properties. THAT allows me to monitor when the positioning of the controls moves.
The three spreadsheets are controlled by both Conditional-Compile code in some forms (that restrict the frames and tabs in the View-Only copy of the form), and by Conditional-Compile code in the PROJECT of each.
It effectively allows me to define the code so that there is a FULL version, a VIEW version (containing only 30% if the forms) and another version that views the data from a different aspect (customers instead of products)
My problem is that I cannot figure out how to export the project details (ie the project conditional-compile parts) to text so I can load them to the Code Library.