Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Using Embedded Excel object to update Notes database.

Posted on 2003-10-24
8
Medium Priority
?
239 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 1200 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 800 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9614237
0
 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month5 days, 20 hours left to enroll

772 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