Tracking down functions in use (Excel 97)

[Paul]

I have inherited a fairly complicated workbook, which
calls various external functions in a number of other
workbooks / XLLs. I'm trying to analyse what these
dependencies are.

Without trawling through all the code manually, I'd like
to get a list of the external functions on which the
workbook and its VBA modules depend. In the VBA editor,
Tools->References tells me which other files I have
dependencies on, but not the names of the
functions/references I'm using in each of these files.

Does anyone know whether there's an easy way to get a list
of what specific functions are being referenced?


Thanks in advance!
Paul

 

[microsoft]

hi paul,

what you can do is select all the vba code and paste into
a text editor w/ sort capability (like editPadPro from jgsoft.com
- free trial download).

in that particular editor, select all & hold Shift + Tab to move
the code leftmost .. then sort (Extras >> Sort alphabetically)

this will help greatly in putting all your Declare statements together
thus giving your needed list.

hope this helps,
theHman