ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   LotusNotes DB extraction onto sheets (https://www.excelbanter.com/excel-programming/325052-lotusnotes-db-extraction-onto-sheets.html)

Willow[_5_]

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,


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com