Difference between revisions of "Getting started in VBA"

From Ribbon Commander Documentation
Jump to: navigation, search
(Before we start)
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
__FORCETOC__
 
 
== Before we start ==
 
== Before we start ==
Before we get started, you need to:
+
Before we get started you need to:
* [[Installation | Install the Dynamic RibbonX framework]]
+
* [[Installation | Install the Ribbon Commander Framework]]
* [[Referencing the Dynamic RibbonX library in VBA | Reference the Dynamic RibbonX library]]
+
* [[Activation | Activate the Ribbon Commander Framework]]
 
+
* [[Referencing the Ribbon Commander library in VBA | Reference the Ribbon Commander library]]
== Referencing the library ==
+
# Create a new project in your favourite office application
+
# Add a VBA reference to the Dynamic RibbonX library (Tools->References)
+
#: [[image:VBAReference.png]]
+
# The library is now ready to use. In the immediate window enter
+
#: <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 here is for excel)
+
#: [[image:UnsupportedExcelVersion.png]]
+
  
 
== Writing some code! ==
 
== Writing some code! ==
Line 21: Line 12:
 
* [[Creating an rxCustomUI object with global dispatch scope in VBA]]
 
* [[Creating an rxCustomUI object with global dispatch scope in VBA]]
 
* [[Creating an rxCustomUI object with local dispatch scope in VBA]]
 
* [[Creating an rxCustomUI object with local dispatch scope in VBA]]
 +
* [[Using XML in VBA]]
 +
* [[Using events in VBA]]

Latest revision as of 18:24, 19 October 2013

Before we start

Before we get started you need to:

Writing some code!

It is recommended that you go through the examples below in the order in which they appear, as each example builds up on previous ones.