Meikel,
I face a little challenge while using vbaxl.
I wanted to achieve the below
Set myRange = Worksheets("Sheet1").Range("A1:C10")
answer = Application.WorksheetFunction.Min(myRange)
I did ;
(def myRange (.. Dispatch (call ws "Range" "A1:C10")(toDispatch)))
Which seems to work, but I was not
Hi,
Am 18.05.2009 um 13:56 schrieb Emeka:
I found that the VisualBasic help of Excel can be easily
translated to such method calls.
Could you explain this further even with links or examples?
I'm sorry. I'm at home now, so I can't check the actual
file name and location in the system. But it
Meikel,
Thanks so much, it is working now.
> I found that the VisualBasic help of Excel can be easily
> translated to such method calls.
Could you explain this further even with links or examples?
(def wb (.. Dispatch (call wbl "Open" @adir)(toDispatch)))
I wanted to use file chooser to ass
Hi,
Am 17.05.2009 um 22:28 schrieb Emeka:
(def c (.. Dispatch (call ws "Cells" 1 1) (toDispatch)))
Here you retrieve the actual cell.
If I have file "hello.xls" already and I have say 'Emeka at Cell 1
1, using the above line could I get 'Emeka .
Yes. Instead of using Add to create a new Wo
Meikel
> (def c (.. Dispatch (call ws "Cells" 1 1) (toDispatch)))
>
Here you retrieve the actual cell.
If I have file "hello.xls" already and I have say 'Emeka at Cell 1 1, using
the above line could I get 'Emeka .
Regards,
Emeka
On Sun, May 17, 2009 at 8:06 PM, Meikel Brandmeyer wrote:
> Hi
Hi Emeka,
Am 17.05.2009 um 21:59 schrieb janus:
I can't figure out how to read cells with Jacob. I need a help.
I'm totally sorry. I forgot to answer your pm. :|
This is the example you quoted. And there you already have
the solution.
(import '(com.jacob.com Dispatch ComThread))
(def xl (
Hello All,
I can't figure out how to read cells with Jacob. I need a help.
Emeka
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Clojure" group.
To post to this group, send email to clojure@googlegroups.com
To unsu
