View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark E. Philpot Mark E. Philpot is offline
external usenet poster
 
Posts: 10
Default Excel XP won't run XLA properly

Gidday,
I am only guessing here but maybe the connection only
allows for x number of users.
-----Original Message-----
Hi all,

I hope someone can help me here. I am an IT consultant
for a program called GoldMine.

GoldMine has recently created a new link between itself
and Excel (there has been a Word link for years already) -


in the form of an xla file (I can also find a

subdirectory
containing a related xml file, but think this is part of
the install, not the actual running files). The link
file has been placed, during the install wizard in the
appropriate XLStart directory on the local C:/

GoldMine network version, and is installed on a mapped
network drive, with a single install accessed by all
computers via a desktop shortcut.

The purpose of this link is to be able to basically do
create a merge function between the database (dBase IV)
files in GoldMine, to place the information in the xls
template.

GoldMine works on BDE5.

The link to Excel has been created and works for Excel
versions 2000, XP and 2003, and I can confirm that it
usually works perfectly for these versions.

However, at some computers (in my case they have all been
XP - no specific SP or build), the link between Excel and
GoldMine simply cannot be started with a BDE -1 error
(can't connect to BDE). To start this link, you simply
click on the item added to the menu - GoldMine, and it
should start up.

This can happen on a network where all other computers

can
do link up fine, but one will not, but according to the

IT
person, all computers have been set up the same, and have
the same automatic updates from MS applied.

This leads me to think that there MUST be some kind of
local environmental issue on that computer ONLY that is
preventing the initial 'call' from the xla being clicked
on to start, and getting through to the BDE.

I have checked that the macro security is 'medium'
or 'low', that the addin is listed as a trusted source,
and that the source has not been disabled (in the Help
section).

I have had the user update to the SP3 version of Excel.

I have made multiple changes to the BDE SHAREMEMLOCATION
to ensure that multiple programs can definitely access

the
BDE, and that these settings are the same as others who
have successful installs.

I am not able to contact the creator of this link
directly, and have also lodged this issue with FrontRange
(GoldMine program manufacturer) for assistance, with no
results to date.

Does anyone have any suggestions on what else I might
check, or look into to see why this link cannot connect
properly?

Thanks heaps,


Wendy


.