Using Embedded Excel object to update Notes database.
Posted on 2003-10-24
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!!