• 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
Office 2011: Excel Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Office 2011: Excel Question


  • Subject: Office 2011: Excel Question
  • From: Christopher Stone <email@hidden>
  • Date: Sun, 22 Jan 2012 02:59:41 -0600

Hey Folks,

What I'm needing to do is compose a data record from Safari (already done) and append it to the next blank row in a data table in Excel.

I can do something like this to paste the tab-delimited text into the correct cells.

set dataRecord to "first_name last_name birthday"

set the clipboard to dataRecord

tell application "Microsoft Excel"
activate
tell sheet "Sheet1" of active workbook
set lastRow to last row of its used range
set rowIndex to first row index of lastRow
select range ("A" & rowIndex + 1)
paste
end tell
end tell

But I would rather do essentially the same thing without involving the clipboard.

Is there a simple way to do that, or would I have to insert all the cell-values piecemeal?

TIA

--
Best Regards,
Chris

 _______________________________________________
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

  • Follow-Ups:
    • Re: Office 2011: Excel Question
      • From: Christopher Stone <email@hidden>
  • Prev by Date: Re: Open Bugs
  • Next by Date: Re: Office 2011: Excel Question
  • Previous by thread: Re: Insert Text Here
  • Next by thread: Re: Office 2011: Excel Question
  • Index(es):
    • Date
    • Thread