I know that there have been previous posts about editing sheets without windows, but I have not been able to work around my problems with the info posted in these threads. Here is my problem:
I have a sheet that stores reference information about zoological taxa (full name of the species, author name, year, Sente citation tag). If I highlight a taxon name in my word processor, an AppleScript will look it up in the sheet and fetch the additional information like the citation tag and paste it into the text. So far so good. But if the taxon is not in the table I would like the script to be able to prompt the user to input the taxon information and then store it in the table, i.e. create a new row with the respective information in the sheet. This last step is where things fall apart, because it seems like it is not possible to add a row to a sheet if the sheet is not opened in its own window. This is utterly inconvenient, because I do not want to have to manually open the sheet before I run the script. Is there at least a way to open the sheet in a new window via a script?