List all Functions

[James]

Is there anyway you can list all the installed functions
in a spreadsheet?

 

[Bob Phillips]

James,

peter Nonely has already done it for you.

You can get his Function dictionary at http://homepage.ntlworld.com/noneley/

 

[Tom Ogilvy]

A possible alternate interpretation:

by installed, do you mean functions used in the worksheet.

If so, you can loop through them (the cells with formulas) and parse out a
list, but there is not built in menu item to do it.

Regards,
Tom Ogilvy

 

[James]

Maybe I should explain a bit more

basically I want to send a spreadsheet to various users
in different countries that aren't networked that checks
the users system and reports back via e-mail what
functions they have installed.

All done except for actually getting the list of
functions the user has installed.

It has to be a list of functions and not addins.

Thanks for the previous replies.

James

 

[Tom Ogilvy]

Still not sure -
you mean go through their installed addins and see what functions those
addins contain?

Regards,
Tom Ogilvy

 

[James]

This is what I was hoping to do, probably not possible,
but just wondering.

 

[Tom Ogilvy]

Even in a workbook, you would have to use the VBE object model to search
through the modules line by line and look for SUB and FUNCTION. So I don't
think the information is made available by Excel and most addins are
probably password protected for their code.

Regards,
Tom Ogilvy