problem calling excel addin via com

jamescowan

New Member
Joined
Apr 10, 2002
Messages
1
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 <j-integra_support@i...>
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 <j-integra_support@i...>
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 <j-
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 ---
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top