How do I make ETrade's DDE addin work in Excel 2003 and Vista?

D

df4000

I used to use ETrade's DDE (Dynamic Data Exchange) addin with Excel 2003 on
Windows XP, but now that I have upgraded to Vista, the ETrade add-in menu no
longer loads up, even though I can see the add-in in Tools-Addins.
 
J

Jon Peltier

Do you mean Excel 2007? Maybe you should check with ETrade whether they have
a version that's compatible with 2007.

- Jon
 
D

df4000

No I have Excel 2003 running on Vista. I've already tried working with
ETrade but they maintain that the add in should work in the environment I've
outlined, even though it doesn't work for me!
 
J

Jon Peltier

Sorry, a lot of people seem to think Excel 2007 is code named "Vista".

One problem I've had in my severely limited testing in Vista is that the I
used to install my add-ins in the C:\Program Files hierarchy, but running as
a regular user (not an admin), the user has no privileges in the
installation directory, so simple things like the program saving data in a
settings file no longer work. I've moved my install directory under
C:\Documents\<username>\AppData (or whatever the precise path is in Vista).
Check where the add-in is installed and if it's trying to save information
in the same directory.

- Jon
 
Top