• 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
Re: Microsoft Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Microsoft Excel


  • Subject: Re: Microsoft Excel
  • From: Doug McNutt <email@hidden>
  • Date: Sat, 19 Feb 2005 09:06:25 -0700

At 12:11 +0000 2/19/05, Gonçalo Miguel wrote:
>Hello i'm a beginner in script. Does some one know how to script inside excel. Like create new lines whitout replacing the one before?

First, you hardly need a script for that. I use  Excel 2001 on an 8500 running OS 9 but it hasn't changed that much in OS X. The Insert menu has an item "Rows". If you select an entire row and exercise that menu item Excel will insert a new row above the row you selected. (It will also modify formulas that might, but won't, apply to the new row.)

"Inside Excel" you can script that operation by selecting the Tools->Macros->Record new macro item. Select that and then execute that "Insert Rows" item. You will see a little palette window with a button in it that will allow you to stop recording. After that use Tools->Marcos->Visual Basic editor and poke around a while to find the macro you recorded. It will look like this:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2/19/2005 by Douglas McNutt
    Selection.Insert Shift:=xlDown
    Application.CommandBars("Stop Recording").Visible = False
    With ActiveWindow
        .Top = 95
        .Left = -717
    End With
End Sub

The only thing you care about is the item:

    Selection.Insert Shift:=xlDown

which is the "script inside Excel" that I think you are looking for. The language is different from AppleScript in that classes and methods have different syntax with that dot indicating that you are using method "Insert" with a property "Shift" set to a constant "xlDown" on an object "Selection".

Excel also has a well regarded AppleScript interface that allows the same kind of things to be accomplished in the "English - like" syntax of AppleScript but you will still have to get accustomed to the class, method, object, property, container culture of modern programming. Have a look at the Excel dictionary using Apple's Script Editor.

If you prepare an Excel macro in VBA - Visual Basic for Applications - you can execute that macro using AppleScript. It's easier to tell, in VBA, which words represent classes and and which are objects and methods. The English of AppleScript seems to obfuscate that a bit.

--

Applescript syntax is like English spelling:
Roughly, but not thoroughly, thought through.
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >(no subject) (From: Gonçalo Miguel <email@hidden>)

  • Prev by Date: Repositioning the AppleScript dialog box
  • Next by Date: Re: Scripting Excel
  • Previous by thread: Re: Scripting Excel
  • Next by thread: Getting list of connected users
  • Index(es):
    • Date
    • Thread