Re: The strange case of the Excel add-in

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi Gonzo,
Do you have more info about the "add-in." Is it a process running in the background? Do you know the API (or code snippet) the developer used to generate the report? What happens if you isolate the machine from the others? Will it work or will the add-in report some error?
Thanks.

-Jiazhi
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Gonzo" <gonzalo.diethelm@xxxxxxxxx> wrote in message news:1183496162.599272.171420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I have a strange situation for which I don't have all the information
I would like, but I am posting here anyway in the hopes that the
symptoms ring a bell in somebody's mind.

I have a Windows 2003 server running Terminal Services. The users
connect to it and run a home-made application (written in Visual
FoxPro). The server also has Microsoft Office installed. The home-made
application can generate a bunch of data that is passed onto Excel,
where an add-in (written by an external developer) will massage the
data with several pivots and generate a report (all done in Excel
within the TS session). The user ends up with two windows open: the
FoxPro application and an Excel window with the massaged data.

This whole thing worked fine until a week ago, were, due to
instability and other reasons, we reformatted the server and
reinstalled everything, including this Excel add-in. Alas, the add-in
doesn't work anymore. Rather, it does work, but in a very strange way:
the Excel window that is launched from the FoxPro application appears
not on the user's session, but on the Administrator's session, on a
separate machine (belonging to someone who works on the datacenter
where this server is hosted; this admin is totally unrelated to our
company). In fact, we only realized the add-in still "works" because
this admin gave us a call asking why he was getting these unexpected
Excel windows popping up all over his screen...

The original developer of the add-in has stated that there is no
reason why the add-in should not work (and it does work), and he has
absolutely zero experience with TS; the symptom sounds to him like
voodoo magic.

Does this wacky description ring a bell with anyone? Thanks in advance
for any hints and best regards.


.



Relevant Pages

  • The strange case of the Excel add-in
    ... I have a strange situation for which I don't have all the information ... I have a Windows 2003 server running Terminal Services. ... FoxPro application and an Excel window with the massaged data. ... reinstalled everything, including this Excel add-in. ...
    (microsoft.public.windows.terminal_services)
  • Outlook2003 C# Framework 2.0 Add-In Problems
    ... i've developed a Add-In for Outlook 2003 using the VSTO2005. ... My developer ... workstation is Windows 2003 Server. ...
    (microsoft.public.office.developer.com.add_ins)
  • Complete path info on Excel window
    ... Is there an add-in that shows the complete path info of the active workbook ... at the top of the Excel window. ...
    (microsoft.public.excel.misc)
  • Re: Excel 2003 bug? VBA custom menu disappearing
    ... You may need to update your add-in to reference the newer Office Object ... > But when excel is shut down and restarted the menu no longer is shown, ... > changes have been done in the VBE environment. ... > in the excel window during execution of opening add-ins (which it did ...
    (microsoft.public.excel.programming)
  • Re: why>?
    ... That's nice when running things on the server. ... Excel VBA is a disease and a threat to national security. ... an add-in from the local drive, ... OK, details are optional, so reports don't have to include details. ...
    (microsoft.public.excel)