Excel problem solved
Excel problem solved
- Subject: Excel problem solved
- From: David Crowe via AppleScript-Users <email@hidden>
- Date: Thu, 7 May 2020 12:23:49 -0600
The trick is “save active workbook”.
Found here:
http://www.cubemg.com/how-to-save-an-excel-workbook-using-applescript/
tell application "Microsoft Excel"
open workbook workbook file name "/Users/User1/Desktop/Email and
Donors.xlsx"
tell workbook "Update Email List.xlsx"
tell worksheet "TIM Emails"
-- Find first blank row
set blank to ""
set searchRange to range ("C2:C9999")
set foundRange to find searchRange what blank
set theRow to first row index of foundRange as text
set value of cell ("C" & theRow) to "test"
end tell
end tell
save active workbook
end tell
- David Crowe
_______________________________________________
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