FORUM PLAN UPDATE: Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.
RE: What have you tried? sneha G sontakke 2.Sep.16 12:03 AM a Web browser Domino Designer All ReleasesAll Platforms
Dim xlApp As Variant
Dim xlsheet As Variant
Set xlApp = CreateObject("Excel.application")
xlapp.SheetsInNewWorkbook = 1
Set newBook = xlApp.Workbooks.Add
sheet = 1
Set xlsheet = newBook.Worksheets(1)
then I am filling the sheet
I could save the workbook on local disk
But I want to store the workbook in ritchtext field of a document without saving it to local disk
Set rtitem = newdoc.GetFirstItem("Daily")
ForAll j In newdoc.items
If j.type=RICHTEXT Then
If j.name="Daily" Then
ForAll o In j.embeddedobjects
If o.type=EMBED_ATTACHMENT Then
Call newdoc.Save( True, True)
It is not working
Could you please help me with this?
Actually I want to do this with scheduled agent on production server
is there any other way to do this ?