Excel Obkect/Classes Names

HCL Domino Domino Forum
1

Greetings!

I have been developing some agents in LotusScript to generate some MS Excel charts. The basic proccesses are OK, but I am having a little difficulty in finding the correct syntax for the objects and classes to configure the workshhet and/or charts.

Example:

I want a title in font arial, body 12, bold.

LotusScript Code:

…

With object.ActiveChart

.HasTitle = True

.ChartTitle.Characters.Text=“Char Title”

.ChartTitle.Font.Bold = True

.ChartTitle.Font.Size = 12

.ChartTitle.Font.name = “Arial”

…

OK, the problem is where to find the correct syntax (“.ChartTitle.Font.Bold = True” or “.ChartTitle.Font = Bold”)

for the various objects and classes. Some of them I got from here, but I would like to know if is there a Classes/Objects Map or List.

Another example: I could’nt find in Excel (Tools - Macros - VBEditor), how to instruct LotusScript to maintain the scale of Y-axis with such and such configuration - Maximum, Minimum, Units etc.

Any help would be my salvation!

Thanks in advance,

Rubens

2

Subject: Excel Obkect/Classes Names info here

You will find what you need herehttp://www.openntf.org/Projects/pmt.nsf/0/1F6C5C7B16317E218625726D004A31A9

3

Subject: RE: Excel Obkect/Classes Names info here

Or, check the faqs, OLE/COM faq. There’s a link to a nice way to understand how to re-configure VBA into LS.

Since the FAQ link has disappeared…

http://www-10.lotus.com/ldd/46dom.nsf/Resources/ForumFAQs?OpenDocument

Doug

4

Subject: Excel Obkect/Classes Names

Rubens,

When you got into the VBEditor in excel, did you open the object browser? It has the list of all of the correct syntax that you are looking for.

One caveat though–if you try to use an excel constant, you will need to define it in your agent because Notes will not know them.

brandt

5

Subject: RE: Excel Obkect/Classes Names

Not sure if this is still valid for all versions of Office - I have not had to use this for some time. Anyway…

http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/e5a86bd4c3df3f1c85256fc700524af7?OpenDocument

6

Subject: Excel Obkect/Classes Names

This question is probably more suited for a MS VBA forum… but here are my 2 cents…

The best way to know the complete api is to open Excel VBE Editor and use the object browser.

You need to add a reference to ‘Microsoft Graph 11.0 Object Library’ to view the Graph API

What I generally do is code the VBA part in VBE and then copy paste into LS(making the minor changes). This way I get to use intellisense making it faster.

rg

Rakesh

7

Subject: Excel Obkect/Classes Names

Easiest way is to open your spreadsheet in Excel, and select Tools - Macros - Record New Macro. Then do all your formatting. Stop recording, and edit the macro you just created. You should find the syntax you need, and most can be easily copied into your LS code.