Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

[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).

[ascheevel]

This might be a good starting point for you writing your own solution.

[Mike Cowie]

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,