Problem Accessing Excel SubMenu
Problem Accessing Excel SubMenu
- Subject: Problem Accessing Excel SubMenu
- From: Willis Grant via AppleScript-Users <email@hidden>
- Date: Tue, 15 Jul 2025 22:17:17 +0000
- Arc-authentication-results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=7TgJ9YM6lWuJZglR0yRn2FFx7RZ6MkfmEqo6cbBLEZU=; b=h5A5cwGGb/rCmK4u1VDF8l74rrRsLeK700yTCn+V1lD3YvY58my281h6QzgqcVTZKK7Q/MSFXdgs3oiYnTGEnpF25hML7FjObdFp3OfJvkGPlE4Eo8DPwPh+SX8d7rpwE5aC8zMdhOFOSifpjT4QVyNlSjmmYo0HEQMRnXiPaWZnOE86i1ZiwCvDblkvQVcDYkTjGKlbEf1Hq67z8/YkGRy5hynTTJaHX8K7lVa7oX24jUSH9DUISgt9RmK4m2Oz0hXzw5azLFwzMzSgFrQpE5fSBUbHi4mlIjfHuOMDpi5DcfT8cw8h7BQPA0PVeoXsTCdgcET160KQbGXxfBt87Q==
- Arc-seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=baz/vVMNDv0xspGZtt2xPboqYcl7P24u0IHFAo2VisHXFRfXkoPx4mea8HtS6+6TSYe1n/4yJvm3C7oZYpwn4YhrAZjK2jH6+5Qtg26ERXgRqD0QdNM2Yje6m54nhAci8t9jqUKZCbcFMztVbx4MlNbfIwy2SiO5z9RQJkBs8foMLxWYaUW9Z687PVIz+wrcx+Tc0d6VCiRM0HFKAmjPF/VGS9P6f/a6WaVWRQRMC2E0+pmkHxYDSV+cErFZ5T9izkQIOLC756FPHlqevbyCsndkObiall0P4eqAA4NGZ2vBbZXjOFKziWBmY2n14snDt2mN+qXvikxBxVkS6vE80Q==
- Msip_labels:
- Thread-topic: Problem Accessing Excel SubMenu
Hi All,
I am not a scripter or coder, but know enough to make a small script.
I am making an Applescript, that will use UI to access a menu button with other
options in Excel
The menu button has a little V at the side, when click, the other options
appear. I want to choose "Unmerge Cells" from the options, to apply to selected
cells.
But I have been unable to get anywhere. When I run the script, it runs smooth,
with no errors but nothing happens.
I have attached a JPEG file of the Excel Menu, with a RED SQUARE around the
area to click.
[cid:e77b5396-8513-459e-a6bc-eecf0adf4d40]
Here's what I have so far.
tell application "Microsoft Excel"
activate
tell application "System Events"
tell process "Microsoft Excel"
repeat until exists of ¬
(1st window whose value of attribute "AXMain" is true)
delay 0.2
perform action "AXPress" of menu button "Merge & Center" of
group 3 of scroll area 1 of tab group 1 of window "Company Analysis-Template 2"
delay 0.2
end repeat
end tell
end tell
end tell
I am using
Mac OS Sequoia. 15.2
Microsoft® Excel for Mac Version 16.98
Script Debugger 7
UI Browser 3
Any help will be greatly appreciated
Kind Regards,
Willis
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden