Exporting VBProject Properties from Spreadsheet

[hicksi]

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.

 

[bobsan42]

Would you be able to provide some code sample and the conditional-compile parts. At the moment I am not sure what exactly you're after?

 

[bobsan42]

a quote from MS:

Conditional compilation constants have a special scope and cannot be accessed from standard code

However check this thread for ideas: How to programmatically change conditional compilation properties of a VBA project

 

[hicksi]

Sorry, I may be confusing in how I describe the problem.
It's not the CODE that I'm worried about. I already have that.
But somewhere in the internals of the VBProject is the place where the window:

is saved. In another spreadsheet, the conditional compiler arguments are different.
I want to read these values so I can write them to file and store them in the code library

 

[Jaafar Tribak]

How about adding those conditional compilation constants as code comments in the ThisWorkbook Module, temporarly export the module and then parse the exported module text and retrieve them.