"faustino Dina" wrote in message
...
What the "Debug/Compile" menu does on the Excel's Visual Basic window?

Does an internal compile of the P-codes used
at runtime, these are stored in the workbook .xls file

Which kind of files it generates? xll?

None

How can I create .xll files for Excel add-ins?


xll files are built using C++ , unless you are an
experienced C++ programmer you will be better
off with either a VB Com Addin (Excel 2000 and later)
which is typically in a .dll file. For this you will need
either a full copy of VB6/VB.Net or the Office 2000
Developer edition

Alternatively use standard VBA addin which is stored in a .xla
file.

A VBA addin is essentially a workbook who's
IsAddIn property is set to True.

The Public functions and subs in the workbook are
available to any other workbook in which its installed
but do not appear in the workbook macro list and
the code can be password protected.

Keith