Solved

Using Embedded Excel object to update Notes database.

Posted on 2003-10-24
8
228 Views
Last Modified: 2013-12-18
Hi, looking for (solution or) code to move notes data to an embedded excel obj, let the user update the data, then move the data back to notes.

We have a super user that insists on updating some parent/child information in excel.  Rather than write all kinds of agents to handle all the tasks excel can do, like autofilter, etc. I'd like to use the excel embedded object in a formula script that displays the data from a the Notes parent_child.nsf in excel format to the user, then puts the updated data back.

Thanks much in advance!!

Bill  G
from Wisconsin


0
Comment
Question by:stanstan30
  • 3
  • 3
  • 2
8 Comments
 
LVL 31

Assisted Solution

by:qwaletee
qwaletee earned 300 total points
ID: 9614191
Use NotesFX.  It is designed to easily share data between a document and the Excel sheet embedded in the document itself, or embedded in teh form the document uses.

The basics are that you declare ranges in Excel that match the Notes field names.

The Excel help fle actually contains references to using it with Lotus Notes this way.  (Well, it used to, I haven't checked if it is still there in more current versions.)
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 200 total points
ID: 9614203
You cannot show whole application in excel, but you can link the document data with Excel using Notes Field Exchange (ref Excel documentation ). This will enable you to transfer data between excel and notes.

There is similar question which I have given in detail explanation on to accomplish this, I will paste the link

~Hemanth

0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9614204
The other possibility is a standalone Excel file that has VBA macros that directly integrate with Notes.  If you know how to program LotusScript, yo more or less know VBA, and you more or less know how to use VBA to access Notes.  Look up COM in the Designer help.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9614237
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:stanstan30
ID: 9614535
Hey guys thanks for the fast response!
I would love to use Field Exchange (Notes F/X 2.0) but I'm having trouble finding it for download eval or puchace.  I checked IBM, Notes, Google and no luck on the product itself.  Does it come within a Suite or something am I missing?

Thanks,
Bill
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9614660
In Notes 5 it is built in, the excel app should support it that is all.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 9614723
Open Designer help, go to Index

Scroll to OLE, expand it, and then expand subtop Exchanging Data under OLE

You wil find a document titled, "Exchanging data using NotesFX"
0
 

Author Comment

by:stanstan30
ID: 9615516
Excellent thanks, I'll check right away!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Missing Rules 1 294
Lotus Notes 8.5 1 140
Find and delete local contacts in names.nsf 5 178
Domino 8 run a specific agent on all nsf in a folder 9 40
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now