Link Notes fields with Excel cells

View member feedback to this tip.

This is an incredibly easy way to link fields in your Notes document to cells in an Excel spreadsheet. This is great for calculating IRR and Net Present Value, or anytime you need a spreadsheet to number crunch something or make a chart for you. This example shows how to link a couple of fields to cells. Once you have this down, the sky's the limit.

Troubleshooting

I've done everything correct, but when I open my spreadsheet everything is blank.

You need to make sure that Windows can find your Notes.ini file. Either make sure the location of you notes.ini file is in your path statement (in your Environment Settings), or MOVE your Notes.ini file into a directory that is in your path. (i.e., C:Windows). Make sure you are using the correct Notes.ini file. Do a search on your C drive and make sure you don't have more than one Notes.ini file. If you do, check the modified dates of the files and keep the one that was modified most recently. Rename the other one to something like NotesOld.ini. Make sure the good Notes.ini is in your Windows path.

MEMBER FEEDBACK TO THIS TIP

This user has rediscovered a feature that was originally implemented in Notes R3 called Notes FX, or Notes Field Exchange. Lotus even had a set of appl

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Other Create a dynamic user-driven navigator for a Notes/Domino application How to apply XSL style sheets to XML views Comparing replicas on clustered Lotus Domino servers Creating a Lotus Notes view column categorized by month Using the XMLHTTP object for integration with Domino or any RDBMS back end Hiding field properties/data from DocProperties box Export a view to Excel without coding Prevent document deletion if there are response documents Switching between test IDs quickly AddParameter to a NotesXSLTransFormer Lotus Domino Designer An introduction to using XPages in Domino 8.5 Top 10 Lotus Notes/Domino coding and development tips of 2008 'Customize this view' options are disabled in Lotus Notes databases Stop response documents from showing in a Lotus Notes form Set a value in a field existing in another Lotus Notes database Display Lotus Notes fields as separate entries in one column An introduction to Lotus Domino Designer Modifying LotusScript code for date and time handling Creating custom Lotus Notes Domino login forms Using LotusScript to retrieve names of fields on a Lotus Notes form

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

ets, including a spreadsheet, project management, charts and others that you could embed into your Notes application.

It was a cool idea that never caught on and most people forgot about it. In fact, I was trying to use this feature a few years ago (around 2001) and I called Notes Technical Support; the technician I talked to didn't know what I was talking about. I ended up writing COM code to generate a spreadsheet on the fly instead of using the Notes FX feature.

—Anthony V.

******************************************

Good tip! This is what I managed to do one week ago. At first, I was not able to see the data exchange between Notes and Excel. I have gone through the Help section and other things, and this is what found that I thought could be helpful.

This technology is nothing but Notes FX.

Thanks, Paul Bleeker for your elaborate description. Your tip made it easy for me to understand.

—Phani M.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip exchange by member Paul Bleeker. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.