Do you just want to know what functions are in each file? The doc tool can do that. To find out what gets called during an execution, you'll need to use some kind of profiler: http://msdn2.microsoft.com/en-us/vcsharp/aa336818.aspx#profilers[^] "Quality Software since 1983!" http://www.smoothjazzy.com/ - see the "Programming" section for freeware tools and articles.

I have my VBA script code in one XL file and then refer this file, from the file with the data. If you clear the data sheets leaving only one (empty sheet) and saves this file as say MyCode.xls Then open the VBA editor for this file, and goto project Explorer. rightclick on the the spreadsheet file, and choose properties. That should enable you to give you code a specific name, its practical if it could start with 'a'. If you then also open the spreadsheet containing only the data, again open the VBA editor, and in the project explorer select the data spreadsheet. Then goto "tools" and "references". This opens the ref's dialog. Here you should be able to locate your code among the many lines. (If the name of your code starts with 'a' it should sort to the top :) Check the box. That should make your code freely available from the datasheet. I use this approach from excel 2003, and the only downside I have found is that the references have absolute paths. Regrads *Henrik

No problem. You only can clean up projects manually. Best, Jun

Take a look at this: http://www.sysinternals.com/ntw2k/source/ntfsinfo.shtml[^]