Hi

I have been trying out the jintegra java com bridge and I have found that it cannot
invoke excel addins programmatically; it is something to do with how excel event handlers work. Below is an email discussion that I had with jintegra.

If there is anyone who can shed any light on this problem, it woul dbe much appreciated.

James Cowan

======================================================


--- In jintegra@y..., _DL J-Integra Support
wrote:
Hi James,

Thank you for your instructions, now it works interactively, and does
not
work programmatically.

The reason why it does not work programmatically is enigmatic for me
also.
The rule of thumb is: what works in VB should also work in J-Integra.
As I mentioned before we are not MS Office experts.
All I could do about it was to compile quickly VB client with the same
functionality.
Alas, it worked exactly like J-Integra.

So, it is not J-Integra problem. It is the problem of Excel add-ins
and how
they are processed in Excel event handlers.

If you manage to find a VB (or VC) example that illustrates how to
make
addIns work programmatically, we would be happy to help you to
convert it
into java - J-Integra code.


Best regards,

Guennady Filkov

J-Integra Support: http://www.intrinsyc.com/j-integra/
Try our new Java/.NET bridge: http://www.intrinsyc.com/jaNET/

Need an immediate resolution? Priority support is available:
http://www.intrinsyc.com/support/hotline.asp


-----Original Message-----
From: jamesmcowan [mailto:jamesmcowan@h...]
Sent: Tuesday, April 09, 2002 07:20
To: jintegra@y...
Subject: [jintegra] Re: Addins



Hi

Via the excel menu, you need to set the tools/addins and add Analysis
toolpak and Analysis Toolpak - vba.

When you switch sheets interactively, you will see A11 and L5 updated.

If you do it via the example program, it fails.

james

--- In jintegra@y..., _DL J-Integra Support
wrote:
> Hi James,
>
> I am sorry to state there is something wrong with your example.
> I can not figure out what is your issue with J-Integra because I
can not
> make your macro work even interactively.
>
> I tried (interactively) both Activating Sheet2 and Tools: Macro:
Macros:
> Run: Sheet2.numberOfWorkingDays()
> The macro from our example works, but your additions always display:
> A10: 01.01.99
> A11: #NAME?
> L5: #NAME?
>
> Please send in working example or advise how to make this one work.
>
>
> Thank you,
>
> Guennady Filkov
>
> J-Integra Support: http://www.intrinsyc.com/j-integra/
> Try our new Java/.NET bridge: http://www.intrinsyc.com/jaNET/
>
>
>
> -----Original Message-----
> From: jamesmcowan [mailto:jamesmcowan@h...]
> Sent: Monday, April 08, 2002 08:19
> To: jintegra@y...
> Subject: [jintegra] Re: Addins
>
>
> Hi
>
> I have modified you vba invoke example so that the vba code looks
like
>
> Private Sub Worksheet_Activate()
> Range("B2:B14").Value = 10000
> Range("B15").Formula = "=Sum(B2:B14)"
> Range("B15").Font.Bold = True
> Range("B15").Font.Color = RGB(0, 255, 0)
>
> Call numberOfWorkingDays
>
> End Sub
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> End Sub
>
>
> Sub numberOfWorkingDays()
> Range("A11").Value = "=WORKDAY(A10, 5)"
> End Sub
>
>
> If you invoke the sheet interactively, you will see that this works
> fine and sets the cell to 10/19/99. If you invoke via java-com, it
> fails and the value #name? is left in the cell.
>
> I have uploaded a copy of JinvokeVBA.xls file.
>
> Hope this makes sense
>
> James
>
> --- In jintegra@y..., _DL J-Integra Support integra_support@i...>
> wrote:
> > Hi, James,
> >
> > Please take in consideration that we are not Excel experts.
> > Could you please provide us with the simplest example/scenario
with
> detailed
> > instructions?
> > Like what values do we have to enter into which cells of Excel
> worksheet,
> > what excel menu options to use, and what result we should get.
> > This example, be it as simple as possible, should reproduce your
> issue.
> > Because I see no problem in extracting data from the range
> containing simple
> > formulas. Unfortunately I have no idea of MATCH and dataimport,
but
> I will
> > definetely help you if you provide me with simple, complete and
> > comprehensive example.
> >
> >
> > Thank you,
> >
> > Guennady Filkov
> >
> > J-Integra Support: http://www.intrinsyc.com/j-integra/
> > Try our new Java/.NET bridge: http://www.intrinsyc.com/jaNET/
> >
> > Need an immediate resolution? Priority support is available:
> > http://www.intrinsyc.com/support/hotline.asp
> >
> >
> >
> > -----Original Message-----
> > From: jamesmcowan [mailto:jamesmcowan@h...]
> > Sent: Wednesday, April 03, 2002 07:03
> > To: jintegra@y...
> > Subject: [jintegra] Addins
> >
> >
> >
> > Hi
> >
> > I am using Workday and Match functions which are part of the
> analysis
> > and lookup add ins. The spreadsheet works fine when I use it
> > standalone but when invoked via java-excel the functions are not
> > found and the cell is left in the state ####.
> >
> > Any ideas why this happens?
> >
> > Typical cell that invokes MATCH looks like this: =IF
(C15="","",MATCH
> > (C15,dataimport!A:A,-1)-2)
> >
> > James
> >
> >
> >
> > _________________________________________
> >
> > Before posting to this list read the faq and troubleshooter:
> > http://www.linar.com/support.html
> >
> > To unsubscribe, send an empty message to:
> > mailto:jintegra-unsubscribe@e...
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> _________________________________________
>
> Before posting to this list read the faq and troubleshooter:
> http://www.linar.com/support.html
>
> To unsubscribe, send an empty message to:
> mailto:jintegra-unsubscribe@e...
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


_________________________________________

Before posting to this list read the faq and troubleshooter:
http://www.linar.com/support.html

To unsubscribe, send an empty message to:
mailto:jintegra-unsubscribe@e...


Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
--- End forwarded message ---