Excuse me if this is the wrong place to post this but I am new here. Although I have over 40 years experience with computers and over 20 years with PC's I have recently purchase a MacBook Pro so I have no experience of the Mac or its software.On my PC I used Excel for all my spreadsheets some of which had macros to automate certain functions. I purchased iWork with the MacBook and gather that the equivalent of macros is applescript. I want to try and recreate some of these macros in applescript and have spent the last few days trying to discover how I use Applescript and Numbers and don't seem to be getting anywhere. Can somebody please point me at a guide, a book or tutorial which covers Applescript and Numbers?I think what I am after is fairly basic but some of the areas I need to start with are1. How do you link Applescript with the Spreadsheet.2.

Run an AppleScript with VB.; 2 minutes to read +1; In this article. Call an AppleScript file from a VB macro in Office 2016 for Mac. Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac. The AppleScriptTask command executes an AppleScript script file located outside the sandboxed app. The following code shows how to call AppleScriptTask from VB. The course is packed full of tutorials, covering every aspect needed to be familiar with Microsoft Excel for Mac 2016. There is also a lot of tips for Mac users in general.

General moving / copying ranges of cells to other cells provided certain conditions are met.3. Clearing cells or filling with other values.Any help will be gratefully receivedElBeardo.

Applescript:tell application 'microsoft excel'-all code here is send to the application, see application suite in librarytell workbook 1 -or tell document 1-all code here is send to the fist document of the application, see document suite in library-also code will be send to the current sheettell worksheet 1-all code here is send to the first sheet of first document of the applicationend tell-back to document 1end tell-back to the applicationend tell-back to scriptTo set an value in a cell in microsoft excel you could do this (there are more ways). I apologise for taking so long to reply but I have spent the last few days trying to understand Applescript and getting nowhere. What I eventually found was that I was overcomplicating matters, it must be the senility setting in!!I was tied up on on how I told Applescript which particular spreadsheet I wanted it to work on and was making the assumption that the Tell Application statement would open Numbers.

After spending several days banging my head against the brick wall and only getting a headache, this morning I opened my spreadsheet copied Nigel's script into the editor, ran it and it worked. Doh!!!I have now found that if I duplicate Nigel's script and set Tell Document 1 to Tell Document 2 and I have two spreadsheets open, the instructions will work on the first or second spreadsheet as appropriate, i.e. Document 1, Document 2, etc work on relative placing.

Is there any way in which instead of saying Document 1 I can give the Tell Document instruction the name of my file so that I don't have to ensure positioning is correct?Thanks for the helpElBeardo. Thank you for that Nigel, I just wonder if I could trouble you with something else. I have spent this morning trying to copy and paste from one cell to another but am getting nowhere.What I currently have istell application 'Numbers'tell document 1tell table 1 of sheet 1global balance1clear range 'j7:p52'copy cell 'e6' to balance1clear range 'n6:n6'set value of cell 6 of column 'n' to balance1end tellend tellend tellThis compiles alright but when i run it I geterror 'Numbers got an error: AppleEvent handler failed.' Number -10000I don't seem to be able to find a reference to this error number.Sorry to be a nuisanceElBeardo:).

AppleScript in Word— do Visual BasicArticle Contributed by AppleScript in Word 2004The article below was written for Word X, 2001 and 98. All is changedutterly in Word 2004, which now has a fully developed native AppleScriptdictionary – in fact it’s probably the largest AppleScriptdictionary of any application on the Macintosh. You may perhaps run intoan occasional bug – these are still early days – but it issolid, reliable and simply amazing after all the years of “makingdo”. So the ‘do Visual Basic’ command is no longer necessaryin Word 2004. On the other hand, it’s still there and it still works,which is good to know in case you run into a problem. More importantly,it means that older scripts using ‘do Visual Basic’ will continueto work in Word 2004.Note, however, that any lines – and I mean any lines – withina Word tell block in an older script and which are not part ofa ‘do Visual Basic’ command will not work in Word 2004.They will have to be rewritten. This is easiest to do by opening yourscript in Word X, saving as Text, then opening it in Word 2004 and rewritingit using the new dictionary.

If you open it as a compiled script instead,all the old keywords will appear in «raw code» which is unrecognizable:you will not know what your original English-like terms were. Saving andopening as text will display the English terms, making it easier to convertto the new keywords – which occasionally may even be the same Englishkeywords hiding very different raw code implementations.If you have spent any time with ‘do Visual Basic’ before,or with Word VBA itself, your knowledge will have not gone to waste. Thenew AppleScript uses the same Object Model as Word VBA, so you will befamiliar with many of the terms and relationships. It actually makes fora very contorted syntax at times, particularly with all the many commandparameters and enumerations (specially named constants), many of whichare similar to each other and just run on, in AppleScript fashion, withoutthe sort of “:=” punctuation used in VBA.The Object Model is very complex, since it reflects the complex realityof Word. Don’t expect it to be like scripting a simple text editorsuch as Tex-Edit Plus.

360 total security keygen download. Earlier Word dictionaries attempted to emulatesuch text editors with the standard Text Suite but failed miserably inpractice since Word’s binary structure could not be forced intoa simple text model without things going dreadfully wrong. So scriptingWord 2004 is definitely a complicated process, with a serious learningcurve.

But what a joy it is to have a scripting model that works.In order to find your way around what is virtually a new sub-languageof AppleScript, you will need the promised Word AppleScript Reference,which will be made available as a download from MacTopia. Unfortunately,at the time of writing (release date of Office 2004 in May 2004), theReference is not ready as yet.

In the meantime you can use the VisualBasic Editor’s Help: the AppleScript terms are almost identicalto the VBA terms except they use “normal” lower-case Englishsuch as ‘auto format’ rather than ‘AutoFormat’ and ‘convertnumbers to text rather than ‘ConvertNumbersToText’. You getthe idea.The very greatest single advantage of the new AppleScript over ‘doVisual Basic’ is that you can now get a result returned from anAppleScript expression in the normal way, rather than hoping you willbe able to find a way to send a string result from VBA by writing to atext file, as described at the very end of this article. That was a verycumbersome workaround – which was not always possible to use – ifyour result were a Word object, for example, or anything else that couldnot be coerced to a string.Word 2004’s new AppleScript is brand new territory, yet to be explored.The rest of this article deals with the techniques needed for Word X andearlier.

Please bear that in mind when reading about the failures of Word’snative AppleScript below: that refers only to Word X and earlier, not toWord 2004.AppleScript In Word X and earlier — do Visual BasicWord X and earlier has a decent AppleScript Dictionary with awell-designed Object Model organized in an orthodox AppleScript manner:suites of classes and events, with classes and their properties predominatingas they should and just a few proprietary events as well as events fromthe Standard Suite. This is a model set-up, similar to Entourage’sand better than Excel’s long list of proprietary events that aretoo numerous to remember, and ought to allow you to script most basiccommands in Word, if nothing too advanced. Unfortunately, unlike Entourageand Excel, Word’s AppleScript has been implemented very poorly.Sooner or later – mostly sooner – Word will crash or error,results will be incorrect and placements of text selection will be wildlyoff-base. Word’s standard AppleScripting is frankly totally unusable. Reminder:this does not apply to Word 2004.But why use AppleScript at all, once you’ve gone to the troubleto learn VBA? You could simply write and install the same macros thatyou would in Word Windows.The reason why you would choose to AppleScript Word via do Visual Basic isbecause you want to run it from outside Word. Do Visual Basic wouldusually be called from an outside, self-standing Applescript application(applet) which is probably coordinating several different applicationsin a work flow that might involve FileMaker Pro, Quark Express, Exceland/or Entourage, or any number of the 100 or so scriptable Mac applications.Or perhaps it might be running as a compiled script in an applicationwith a script menu, such as Entourage: Entourage provides the only meansto access the Office Address Book since Word’s VBA cannot do so,and thus provides a means of including contact information in Word viaAppleScript.

But, being too lazy to make sure that this site actually conforms to the policies which would really be what I should do instead of individually answering personal a2a questions like this on. Download spongebob episodes online free. Yes I said those words twice on purpose cuz it's silly and it pisses me off cuz I seriously answer this question 13 times a day now but each one I have to individually answer since I'm a partner member hell to the policies of what can be this diculous Forum. Like this, where I could just post the freaking link, I did that and I just kept getting tags tags and tags from the moderators about links. Anyway, point being so I don't get kicked off the site as a partner and making sure I follow policie.

(My own “Address Word Letter” and “PrintTasks Lists” scripts do just that, for example.) Or perhaps youwant to run a script from the OS X script menu.