Database Reference
In-Depth Information
Figure 10.1
Importing the SmartView.bas.
to implement the vBA functions in Excel, first import the Smartview.bas file into
your workbook via the vBE. to import the Smartview.bas file, right click on your proj-
ect in the Project pane, then select Import File and browse to your local machine's install
directory of Smart view (Figure 10.1). This directory is usually found at C:\oracle\Smart
view\Bin.
If this is the first time you have used the vBA environment to program with Smart
view, you will likely need to add a reference to hsAddin.dll, found in the same directory
as Smartview.bas. to add a reference to hsAddin.dll, select tools, references, then select
Browse and navigate to the Smart view directory, then select hsAddin.dll, as shown in
Figure 10.2.
now that the Smartview.bas module is present, you automatically have declarations
necessary for all the Smart view vBA functions to work.
Tip:
to figure out how to code a complicated bit of functionality in Excel, use the
record macro function to “record” yourself manually performing that task. Excel will
create the code for you.
newer features in the Smart view vBA functions are a valuable set of enhancements. A
few new functions are highlighted in table 10.1.
10.4.3 Setting and Managing Options
The Smart view vBA functions provide a set of functions that allow you to manage
Smart view user options. Three main functions include:
1. hypSetoption
2. hypSetSheetoption
3. hypSetglobaloption
hypSetSheetoption is specific to the currently active sheet. The sheet name
parameter is unused by Smart view. table 10.2 provides some clarification and
