LotusNotes DB extraction onto sheets
I need to access LN DB from excel and import the content onto sheets.
The way I do (like a stone age developper) :
1- Access to LN : sendkeys "{%Tab}" (I don't know how to activate another
application which is not Microsoft appli!)
2- Export views into files : sendkeys codes (I don't know how to access menu
and export file with another way)
3- Copy /paste content of a file onto sheets and delete file.
It works but I guess it exists a far more efficient method to do so, please
if you experienced the same wondering and passed it, help with simple exemple
I can adapt to my issue. Thanks in advance.
A Little detail : I need this to work with Excel 2003 AND Excel 97...
Regards,
|