Difference between revisions of "Getting started in VBA"
From Ribbon Commander Documentation
(→Referencing the library) |
(→Referencing the library) |
||
| Line 8: | Line 8: | ||
#: [[image:VBAReference.png]] | #: [[image:VBAReference.png]] | ||
# The library is now ready to use. In the immediate window enter | # The library is now ready to use. In the immediate window enter | ||
| − | #: <syntaxhighlight lang="vb" | + | #: <syntaxhighlight lang="vb">?rxCustomUI.defaultInstance.targetOfficeVersion</syntaxhighlight> |
#: This should print the major version of the office platform you are using. If you are running in an older version of office you will get a runtime error instead (the error message is for excel in this case) | #: This should print the major version of the office platform you are using. If you are running in an older version of office you will get a runtime error instead (the error message is for excel in this case) | ||
#: [[image:UnsupportedExcelVersion.png]] | #: [[image:UnsupportedExcelVersion.png]] | ||
Revision as of 16:47, 10 March 2013
Prerequisites
Before you get started install Dynamic RibbonX on your PC (see Installation)
Referencing the library
- Create a new project in your favourite office application
- Add a VBA reference to the Dynamic RibbonX library (Tools->References)
-
- The library is now ready to use. In the immediate window enter
-
?rxCustomUI.defaultInstance.targetOfficeVersion
- This should print the major version of the office platform you are using. If you are running in an older version of office you will get a runtime error instead (the error message is for excel in this case)
-
-
