excel script does not work
excel script does not work
- Subject: excel script does not work
- From: email@hidden (Gerd)
- Date: Sun, 18 Aug 2002 22:13:59 +0200
Hallo Jay,
thank you for your answer. I just tried:
set Firma to "Hamburg"
tell application "MS Excel"
set Value of Cell "R2C1" to Firma
end tell
and i get the same error:
Microsoft Excel got an error: can't set value of cell "R2C1" to "Hamburg"
Any idea what is wrong ?
regards
Gerd
Am Sonntag den, 18. August 2002, um 22:02, schrieb Jay Young:
>
Hi Gerd,
>
>
I ran your Script on my machine (OS 10.1.4 with AS 1.8.2 and Excel X)
>
and it ran fine. And your syntax looks fine so I'm not sure why it's
>
not working for you. You might try something like this and see what
>
happens (see if it shows where the script is getting stuck):
>
>
-------------------------------------
>
set Firma to "Hamburg"
>
>
tell application "MS Excel"
>
set Value of Cell "R2C1" to Firma
>
end tell
>
-------------------------------------
>
>
Let me know if you still can't get it to work and I'll look at it some
>
more. good luck!!
>
>
Jay
>
>
On Sunday, August 18, 2002, at 02:44 PM, Gerd wrote:
>
>
> Hallo,
>
>
>
> i tried to run following script under OS X 10.1.4 and Excel (Office
>
> X). But i always get an error message.
>
>
>
> set Firma to "Hamburg"
>
>
>
> tell application "MS Excel"
>
> try
>
> tell Worksheet 1 of document 1
>
> set Value of Cell "R2C1" to Firma
>
> end tell
>
> on error errMsg number errNum
>
> display dialog errNum
>
> end try
>
> end tell
>
>
>
> error message - 10006
>
>
>
> Text: Microsoft Excel got an error: can't set value of cell "R2C1" of
>
> Worksheet 1 of document 1
>
> to Firma
>
>
>
> Does anybody know the reason ??
>
>
>
> Thanks for any help
>
>
>
> Gerd
>
> _______________________________________________
>
> 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.
_______________________________________________
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.