View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Willow[_5_] Willow[_5_] is offline
external usenet poster
 
Posts: 12
Default 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,