• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Excel problem solved
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Prev by Date: Re: NSScreen's screens() changed in Mojave
  • Next by Date: open for access command
  • Previous by thread: Re: NSScreen's screens() changed in Mojave
  • Next by thread: open for access command
  • Index(es):
    • Date
    • Thread