Tracking down functions in use (Excel 97)
 

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

Tracking down functions in use (Excel 97)
 

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

"Paul" wrote in message
...
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