Page 1 of 1
Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook
Posted: Tue Nov 29, 2022 10:14 pm
by JohnO
I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters convert to). So the extract would basically be: Worksheet name, cell address, full formula containing the evaluated parameters).
Re: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook
Posted: Fri Dec 02, 2022 3:27 pm
by ascheevel
This might be a good starting point for you writing your own solution.
Re: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook
Posted: Mon Dec 05, 2022 2:20 pm
by Mike Cowie
JohnO wrote: ↑Tue Nov 29, 2022 10:14 pm
I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters convert to). So the extract would basically be: Worksheet name, cell address, full formula containing the evaluated parameters).
Hi JohnO,
Not sure if this free, TM1-specific
Audit Report tool, which you can download from
here, might be of use.
Regards,