search

gueleh / flowframework2

A framework for application development in Excel VBA
6 stars 0 forks source link

Export of Relevant Data for Version Control, including txt-Files for Data not in VBA #5

Open gueleh opened 1 year ago

gueleh commented 1 year ago

The Workbook contains various structurcal data, which are relevant for the an Excel VBA application to work properly, such as the defined names. For these data no version control is possible. This feature shall automatically export these data and also all code modules (for people who don't use MZ Tools or similar tools).

gueleh commented 1 year ago

In addition to fixed structures like the names of the workbook and the worksheets, it also should be possible to do this for specified ranges of worksheets, e.g. a range containing the worksheet params and also other params which do have an effect on the code execution (not: data).

gueleh commented 1 year ago

It will require the permission to programmatically change the VB project, thus this has to be checked and gracefully handled if not allowed by the settings.

gueleh commented 1 year ago

Move this to its own issue: Add control tables for f and af, determining wks contents for which txt files have to be generated for version control, allowing for more than one range. For each cell in each range, output pairs of address and cell value, take the codename of the wks as part of the filename for the text-file.