Recorded script doesn't run
Recorded script doesn't run
- Subject: Recorded script doesn't run
- From: "Rebecca Felts" <email@hidden>
- Date: Fri, 24 Aug 2001 11:42:06 -0500
I am trying to capture the merging of two Excel cells. I record the
following:
tell application "Microsoft Excel"
Activate
Select Range "R1C1:R1C2"
set HorizontalAlignment of Selection to xlCenter
set VerticalAlignment of Selection to xlBottom
set WrapText of Selection to false
set Orientation of Selection to 0
Merge Selection
end tell
But upon playback I get the error message: "Microsoft Excel got an error.
Selection doesn't understand the Merge message"
The above script recorded the use of the Excel Merge/Center button.
Although I can merge by using the cell format dialog also, that merge isn't
even recorded.
How can I script a cell merge?
Rebecca Felts
Software Engineer
Team Labs Corporation
www.teamlabs.com