hi,
I am lookinh forward to create a excel template in lotus notes. Lets say; we have a wookbook. In that we have 5 sheets. On sheet 1 there is some data & on sheet other sheets we have some related data & pie charts & graphs related with that data.
All i want is; to use this wookbook as a template; include this in lotus notes & when ever user click on an action button ( i want to call this excel sheet on a button click); he/she is able to access this template. And as per user requirements, they can edit/modify the data in the sheets & save them to notes.
how can i do this. i know how 2 create excel sheets in LN. ( ex:- using the
Set xlobject = CreateObject(“Excel.Application”)
Set NewBook = xlobj.Workbooks.Add
& adding sheet into it using:-
Set xlSheet = xlobj.Sheets(“Sheet1”) )
can anyone please guide me how to put this default data on the sheet & use it as a template. i want user to edit the sheet & save its new copy.
thanks in advance,
Ray