|
|
|
|
|
|
|
|
|
|
|
|
|
|
OLE automation primer (continued)
Once we have a total, we need to get that value back into Notes, so we will use the same syntax to get a handle to our cell, .cells(5,1), that we used before, but append a .value to it to get the value stored in that cell.
'Get the total generated in Excel and put it in the Total field in Notes
doc.Total = oexcel.cells(5,1).value
|
Now we're done with Excel. Let's close the workbook that we created without saving it, and Quit Excel.
'close the file (we won't save it in this example)
oexcel.ActiveWorkbook.Close(0)
'close excel
oexcel.Quit
|
Setting our object handle to nothing is simply good programming. It destroys the reference to our object, which makes this object no longer accessible from our code, but in this case, we closed Excel, so we don't need this object any longer. This is simply a cleanup routine, but it's a good idea to go ahead and include it in your code.
'always set the object equal to nothing, which destroys it.
oexcel = ""
|
A closing caveat (of course)
Using OLE automation, other applications can lend functionality and enhance your Notes applications, but watch for performance issues. OLE automation is a wonderful thing, but it is a performance hog. I have found that it's better to use scheduled Agents that run on off-hours, when doing OLE automation server-side. On the client, your users might be more forgiving.
Now, this little bit of simple addition could have been done in Notes, but the idea is to get familiar with OLE automation and Excel. Experiment with this code -- use it as a starting point. Feel free to comment or ask questions on the PowerBoards or via email if you get stuck!
Chris Stoner, formerly Chris Brown, is a Principal CLP Notes Developer (R4 and R5) currently based in the Washington, DC Metro Area. Other Notes Developers may recognize Chris as her alias, Green Jellybean, which is the nickname for her green Toyota RAV4. She can be contacted at green_jellybean@bookideas.com.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Sophisticated Meets Simple For Document Management
Share. Control. Manage.
Documents, emails, and content in the context of how work is done.
Native to Lotus Domino. The User Experience unseen for Lotus Domino.
Do more with less. Really.
See the possibilities Docova unleashes for Lotus Domino. |
-- Advertisement --
Mark your calendar for in-depth Lotus training, May 12-14, Boston
Join experts and peers May 12-14 in Boston for educational and networking events that deliver real-world Lotus training so you can increase productivity and efficiency in your company, advance your skills, and squeeze the most from your current environment. One registration gets you into THE VIEW's Admin2010 and Lotus Developer2010.
Register by April 10 to save $200. |
|
|
|
|
|
|
|
|
|
|
