Insert column in Excel 2004

Scripting Forums AppleScript | Mac OS X
,
#1

I’m sure that this is really easy but I’m completely lost with the Excel dictionary. What’s the syntax for adding a new column in Excel 2004?
Also while I’m here is it possible to set the format category of a cell with applescript, i.e. a number, percentage, custom field?

Please help if you can, I’ve been going round in circles for hours.

Many Thanks

Kieran

#2

Hi Kieran

to insert a column you can use this code:

tell application "Microsoft Excel"
	insert into range column 3 of sheet 1
end tell

Do you know the Microsoft’s Excel AppleScript Reference:
Excel 2004 AppleScript Reference

To explore the structure of properties in Script Editor,
this code shows the properties of the active cell

tell application "Microsoft Excel"
	tell active cell
		set Cellprops to properties
	end tell
end tell
#3

Thanks StefanK that really helps alot.

Kieran