Numbers AppleScript: paste clipboard as rows below

Hi Mark,

This works here:

set theDoc to POSIX path of (path to home folder as string) & "Sites/MySubfolder/MyDoc.numbers"

tell application "Numbers"

opentheDoc

-- etc.

end tell

As does this:

set theDoc to (path to home folder as string) & "Sites:MySubfolder:MyDoc.numbers"

--return theDoc

tell application "Numbers"

openfiletheDoc

-- etc.

end tell

Maybe a variation of one of these will work there.

SG

Since you say you are running the script from the target folder perhaps this will give you the path you want.

set pathToMe to path to me as string

set pathToMe to pathToMe's text 1 thru -16

tell application "Numbers" to open pathToMe & "MyDoc.numbers"

The -16 is chopping off the name of the script (in my case 'Untitled 2.scpt') so you are left with just the path, to which you then append the name of your Numbers document. Instead of hardwiring the relevant number in, you could of course get fancier and have the script detect the number of characters to chop off. But if your script is always named the same on each machine, then you might not need to do that.

SG

Instead of hardwiring the length of the script's name into the script, you may be able to do something like this to get the path to the folder in which the script is located. Tested running the script in Script Editor.

set pathToMe to pathToMe's text 1 thru -((length of (front document's name as text)) + 1)

SG

To get the directory where current script is located, you may use this:

set cwd to do shell script "dirname " & (path to me)'s POSIX path's quoted form

Or this:

tell application "System Events" set cwd to (path to me)'s container's POSIX path end tell

Note that if script is not yet saved, it will return directory where current application (e.g., Script Editor) resides.

H

Hi Mark,

Lots of ways to do this, it seems.

Here, this also works well, when run from Script Editor. (Unless you're working with shell scripts, not sure POSIX path has an advantage.)

tell application "System Events" to set myPath to (path to me)'s container's path

tell application "Numbers" to open myPath & "MyDoc.numbers"

SG