((( [logo]Racket )))Need Help?
AboutDownloadDocumentationPLaneTCommunityLearning

[plt-scheme] mysterx and excel

From: Paul Steckler (steck at stecksoft.com)
Date: Mon Jul 14 22:48:29 EDT 2003		 
>   (define r (com-get-property sheet "Range" "A1"))
> 
>     com-get-property (property "Range"): expects 1 to 2 
> arguments, given 0
> 
> Hmm, given 0?  What about "A1"?

> The following corresponding Visual Basic code works.
> 
>    Set r = sheet.Range("A1")

"Range" is an `indexed' property, as your VB code shows.
So I think you want

  (define r (com-get-property sheet '("Range" "A1")))

-- Paul
Posted on the users mailing list.