Import lotus notes view data from Excel

30 pts.
Tags:
Excel macros
Lotus Notes
Microsoft Excel
I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Not sure if this helps. It would run from Notes, rather than in Excel.

<a href=”http://www.bluestream.org/Domino/ExportToExcelViaNotes.htm”>http://www.bluestream.org/Domino/ExportToExcelViaNotes.htm</a>

Otherwise, this is a non-script solution available on Domino Power.

<a href=”http://www.dominopower.com/issues/issue199810/excel001.html”>http://www.dominopower.com/issues/issue199810/excel001.html</a> – This article will show you a — in few simple steps — how to turn a Lotus Notes view into an XML-equipped Web page. This new page can not only be viewed by a Web browser, but opened by Excel 97 — complete with formulas and summed columns. Further, you’ll see how to take one small XML step to condense large amounts of information into flexible Excel pivot tables, and how to use Web agents to work around limitations of Notes views.

Search openntf.org for code that will do that.
The other choice is to select the docs in the view and copy as a table (r7 & up). You can then paste it into excel.

If this is to be done all the time then you can use NotesODBC and have excel pull the data as ODBC, this lets you just do it in excel and not have to export or use com to write directly to excel

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Witold2008
    Thank you! It is not exactly what I'm looking for but it is very interesting, I will try the Lotus Notes view into an XML.
    30 pointsBadges:
    report
  • SlikTool
    I may have some code that could be used, only it will require Win32 clients only. Most of it is done via COM. Another option, if you are familiar with SQL is to use the NotesSQL driver and connect to your DB via SQL within Excel. I believe here though, you work with the form or the view as a table.
    1,840 pointsBadges:
    report
  • Witold2008
    Thanks for all yours tips, I'm not familiar with ODBC or SQL or COM but I think that my solution is there Actually I need to select docs in view and copy as table and then paste it into excel, but I have 4 table to update like that each time, so I need something to be more efficient. Which of your suggestion is easiest to apply for my case?
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following