Using Embedded Excel object to update Notes database.

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

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.)
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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

stanstan30Author Commented:
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?

In Notes 5 it is built in, the excel app should support it that is all.
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"
stanstan30Author Commented:
Excellent thanks, I'll check right away!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.