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