No one wants to repeat the same task over and over again. Excel
gurus especially hate the drudgery of repetitious work like data entry and formatting cell
after cell after cell. Fortunately, Excel offers serious time-saving
tools called macrosminiature programs that
automatically perform a series of steps within any workbook.
Excel macros are written in a full-blown programming language
called VBA (short for Visual Basic for
Applications). VBA is a scaled-down version of the incredibly popular
Visual Basic programming language, and it's fined-tuned for Excel and
other Office programs. Fortunately, you don't need to be a programmer to
use VBA. In fact, you can create a simple macro using a special Excel
tool called the macro recorder. The macro recorder works like a tape recorder, but instead of
recording audio, it records keystrokes and mouse actions as you perform
In this chapter, you'll learn how to use the macro recorder, how
macros work, and where Excel stores them. You'll also learn how to
attach macros to shortcut keys, the Quick Access toolbar, and buttons in
your worksheet. In the next chapter, your exploration goes one step
further and plunges into the VBA language.
This dramatic limestone crag riddled with caverns is both a natural marvel and religious site with its holy Hindu shrines and colourful dioramas.
Switch track from the drone of city traffic and air-conditioning to birdsong and all-encompassing greenery at this jungle park.
Breathe easy at this classic, colonial-era, high-altitude resort on the Selangor–Pahang border that is also a top bird-spotting destination.
Travel from city to coast, pausing at a range of fun attractions and sights including a giant water theme park, a mega-mosque and Klang’s vibrant Little India.
Malaysia’s administrative hub is a showboat of daring contemporary and Islamic heritage architecture arranged around a pretty, artificial lake.
One of Malaysia’s national treasures, the venerable Hindu temples housed in and around these limestone caves have been a devotional sight for more than 120 years. It’s always an atmospheric, colourful and fascinating place to visit but no more so than in late January or early February when a million pilgrims converge on the caves during the three-day Thaipusam.
A supervisee’s dream about the supervisor is presented in this chapter. The dream coincides with the patient’s reverting to her earlier symptoms during the termination phase. As a result of this the psychotherapy had to be prolonged.
Unfortunately, little is seen in the literature on the dynamics and dysfunctions of supervision. In his important paper, Pedder (1986) indicates the difficulties that may arise when transference problems occur in psychotherapy supervision towards the supervisor. Heising (1976) and Sandell (1985) also pointed out the threat of the negative influence that supervision might have on the therapeutic outcome.
The objective of this study is to elucidate further the trans-ference-countertransference issues that arise between trainees and supervisors, as well as their consequences on the psychotherapy.
Dr D was a third-year psychiatric resident, married, in her mid-thirties. She was considered a very intelligent young physician, and everyone felt that she was pleased to present the material of her cases. She was very enthusiastic to have her first patient in psychotherapy, and after the termination she asked to be assigned a second case of brief psychoanalytic psychotherapy (Vaslamatzis & Verveniotis, 1985). Her second case was a female patient who presented with anxiety attacks and somatic symptoms. She was single and clung to relationships with motherly-behaving older men. The patient’s mother had died three years previously, and it was at that time that her symptoms had first appeared. The evaluator had been the supervisor himself, who had decided about the patients suitability for brief psychotherapy (up to 30 sessions). The patient had agreed to this limit.
Microsoft’s .NET Framework, usable with Visual Basic, C#, and C++ (among other languages), offers a shared regular-expression library that unifies regex semantics among the languages. It’s a full-featured, powerful engine that allows you the maximum flexibility in balancing speed and convenience.†
Each language has a different syntax for handling objects and methods, but those underlying objects and methods are the same regardless of the language, so even complex examples shown in one language directly translate to the other languages of the .NET language suite. Examples in this chapter are shown with Visual Basic.
Reliance on Earlier Chapters Before looking at what’s in this chapter, it’s important to emphasize that it relies heavily on the base material in Chapters 1 through 6. I understand that some readers interested only in .NET may be inclined to start their reading with this chapter, and I want to encourage them not to miss the benefits of the preface (in particular, the typographical conventions) and the earlier chapters: Chapters 1, 2, and 3 introduce basic concepts, features, and techniques involved with regular expressions, while Chapters 4, 5, and 6 offer important keys to regex understanding that directly apply to .NET’s regex engine. Among the important concepts covered in earlier chapters are the base mechanics of how an NFA regex engine goes about attempting a match, greediness, backtracking, and efficiency concerns.