>>Did anyone in here create Excel-Charts via LotusScript? I tried to teach
>>to myself with an Excel-Makro,
>>but I am stuck.
>Are you using a 'template' spreadsheet with a predefined data range and
>What does the macro do?
Here the situation but more detailed:
Until now i don't have any excel-template. I thought just to do everything
in Script without depending on
pre-programmed templates or makros. I succeeded in opening excel invisible
and writing my data into
a standard sheet. Code example (patchwork of some internet-resources):
Dim xlApp As Variant
Dim xlSheet As Variant
Dim xlChart As Variant
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = False
Set xlSheet = xlApp.Workbooks(1).Worksheets(1)
.Range("B7").Value = "42 is the answer"
.Range("B8").Value = 42
.Range("B9").Value = "don't panic"
.Range("B10").Value = "Test"
Well, so far so good, I have an Excel-Sheet with my data.
Now it's possible to call an excel-makro to do the drawing.
1. pre-programmed makro required
2. How to get the control of program-flow back to Notes? I want to have the
chart in a Notes-Document, but
Script will not know when the excel-makro ended with for example finally
copying the chart to the clipboard.
Second possibility: use the Objects and methods of excel to do this via
1. i am not very experienced in VBA, so examples would be useful
2. There are statements in VBA which could be useful (like ChartWizard() ),
but I don't know how to compile the
syntax to LotusScript.
For example ChartWizard requires parameters without brackets.
Charts("Diagramm1").ChartWizard Gallery:=xlLine, HasLegend:=True,
I would appreciate a hint or two for any of the above problems, including
getting the diagram back to notes
(maybe with a better solution than the clipboard)