Re: scripting excel
Re: scripting excel
- Subject: Re: scripting excel
- From: David Wignall <email@hidden>
- Date: Wed, 04 Feb 2004 16:40:56 +1300
on 4/02/2004 3:12 PM, Shelly Mendlinger at email@hidden wrote:
>
hi,
hi
>
First, how to set a title to the new document?
>
create new document with title "NEW" doesn't work
tell application "Microsoft Excel"
Create New Workbook With Properties {Name:"foo"}
-- compiles but doesn't quite work, no name for workbook. So:
Save ActiveWorkbook In (((path to desktop) as Unicode text) & "foo.xls")
>
next, how to enter data into cells: addfield rowfield {string1, string 2}
>
gets "addfield can't continue
set Value of Range ("R1C1") to "hello world"
set Value of Range ("R1C2:R4C2") to 42
set Value of Range ("R1C3:R4C3") to {{4}, {2}, {"hello"}, {"world"}}
end tell
>
any and all help would be appreciated.
Using R1C1 (row/column) syntax avoids XL thinking you want column C when all
you want is cell C1
>
Thanx
hth
Dave
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.