Database Reference
In-Depth Information
Function isSVError(lErrCode As Long) As Boolean
Dim res As Boolean
res = False
If Not (lErrCode = 0) Then res = True
isSVError = res
End Function
10.5 aFterthoughts
For those who can provide solutions outside of the normal range, people who enjoy
making the square peg fit into the round hole, requirements can creep like a heavy fog.
gathering requirements for a solution that transcends normal functionality must be
an iterative process. What users ask for and what they really want are often two very
different things. With this in mind, while it might be tempting to quickly code what is
being asked for merely to show it can be done, it is preferable to take the time to verify
and validate the requirements through mockup and dialog. you may be surprised how
different the user requirements really are compared to what you initially thought they
would be.
much of the discussion and instruction in this chapter centers on automating Smart
view and manipulating it programmatically with the Smart view vBA functions. many
solutions have been created using these processes, techniques, and tools. however, one
thing to keep in mind with regard to Excel and its programmatic capabilities—less is
more. Code written in vBA is really script, and usually inefficient script. not much can
be done specifically within the vBA environment to optimize this. Therefore, the reader
should strive to keep it simple.
Search WWH ::




Custom Search