Database Reference
In-Depth Information
Figure 10.2
Adding a reference to HsAddin.dll.
examples of some of the more complicated options that can be managed by
hypSetSheetoption.
hypSetoption allows you to set a default set of options that can be overridden by
hypSetSheetoption, or by hypSetoption itself. hypSetoption is easier to use in mul-
tiple sheet workbooks because it doesn't require you to activate each sheet for which you
wish to set options.
hypSetglobaloption provides access to global properties like the verbosity of
logging, whether or not to use Excel formatting, and navigating without data.
10.4.4 Connecting, Logging In, and Refreshing Forms
Automating the connection and login process is one of the best ways to enhance the user
experience in Excel. By preparing and automating connections ahead of time, you can
simplify and unify your users' experience. A simple login dialog can be creating using
standard Excel vBA forms.
Why would you want to create your own login dialog? maybe you only need the out
of the box functionality provided by Smart view; however, if that were the case you
probably wouldn't be reading this section. Providing your own login dialog box allows
some additional flexibility and capability. For example, you can create your own look
and feel, use particular fonts, company logos, and add special instructions in a custom
login dialog. A custom login dialog also provides the ability to capture things, such as
the user name or any other information you want the user to provide.
10.4.4.1 Connecting and Logging In
Below is an example of code used to create connec-
tions and login to Essbase. The error handling used here is explained in Section 10.4.13
(Error handling).
