Search code examples
vbapowerpointlotus-notesoffice-interoplotusscript

How to import Microsoft Office constants (msoTrue, ppLayoutText...) into LotusScript?


I am trying to programmatically make a PowerPoint presentation from the contents of a Lotus Notes document. This is relatively straight-forward using CreateObject("Powerpoint.Application") but I fail to find a way to access the various constants that are used in VBA.

One solution is of course to hard-code the (ten or so) values into my script, but for obvious reasons I'm a bit uneasy about that solution.

Is there a way to lookup the value of for example msoTrue or ppLayoutText with LotusScript? For example a way to query the Powerpoint.Application object for the values?

(In more compentet languages adding various Interop libraries seems to do the trick, but I haven't found a way to do that in LotusScript.)

Edit I prefer a solution that will work without any extra installation of software or dlls, apart from Office.


Solution

  • This is what I use for MS Office constants: Microsoft Constants Database. There is a script library that has recently been added for Word and Excel.