Hi
I want to create a multiple select list box in excel through Lotus Script.Can anybody help me?
Thanks
Subject: don’t try. Use Excelbasic instead
Hi Amruta,don’t try. While theoredically you can call the whole Excel API from Lotus Script is is quite painful compared to develop an native Excel Macro. So our best practise is to write values from Notes to Excel (Cells or properties) and then to launch an Excel Macro.
This has the advantage, that you can ask an Excel expert to do the macro without training her/him in Domino. Nice clear cut interface.
Drawback: you must make sure the macro is available (put it in the template)
HtH
stw
Subject: RE: don’t try. Use Excelbasic instead
How does one put the macro in the template? Thanks, Diane