Hi,

This is an update for this issue.

There's no easy way to access the IDispatch OM (i.e. what you'd use if you
were programming in VB/VBA) from an XLL. XLLs use the XLM programming
language to talk to XL. The best reference for the XLM programming
language is macrofun.hlp, available he
http://support.microsoft.com/kb/128185. Add either "xlf" or "xlc" to the
command you wish to call from Excel4()/Excel12(). They should all be
defined in xlcall.h.

The archived XLL documentation is available at:
http://msdn.microsoft.com/archive/.
Expand the following: Office Solutions Development / Microsoft Office 97 /
Office 97 / Product Documentation / Excel / Microsoft Excel 97 Developer¡¯s
Kit.
Click ¡°Introduction¡± - that should get you to the first "page" of the
book.

For your scenario, did my previous suggestion help you, e.g. write a C++
COM Addin to manipulate the Excel Object Modal and which will do almost all
the job you do with Excel Menu/toolbar.
This is the Excel Object Modal reference which is installed with Office
problem.(below is for Office 11, excel 2003)
<Program Files\Microsoft Office\OFFICE11\1033\VBAXL10.CHM

If you still have any other concern, please let me know.


Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.