List all Functions
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
"James" wrote in message
...
This is what I was hoping to do, probably not possible,
but just wondering.
-----Original Message-----
Still not sure -
you mean go through their installed addins and see what
functions those
addins contain?
Regards,
Tom Ogilvy
"James" wrote in
message
...
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
-----Original Message-----
Is there anyway you can list all the installed
functions
in a spreadsheet?
.
.
|