change a xla macro for a new version in XP

  • Thread starter Thread starter Jalou
  • Start date Start date
J

Jalou

Hi !
I wrote a quite complicated macro to distribute among
a group of users. I have sometimes to add a new function
to the macro or to correct a few bugs. I had no problem
with having the users updating the macro just by puting
the new one in replacement of the old one until users
started to have Win XP instead of Win98SE. For these
users Win XP would always find the old macro even if
it has been erased from the directory where it was
supposed to be ! Does somebody have a safe procedure to
change a macro for a new version having the same name
in XP ?

thanks in advance for your help
 
Hi
It's not quite clear, but I guess you are replacing the whole .xla
file with the new version?
You will probably find that users have multiple copies of the .xla
file, and the one the Excel is pointing to in the AddIns list is not
the one you have replaced. Unfortunately, the AddIns list does not
tell you where a particular AddIn is.
I have an "About" menu item on my AddIns which tells me where it is,
simply:

msgbox "AddIn is located at " & Thisworkbook.Path, "About this AddIn"

Then I know I'm deleting the right file.

regards
Paul
 
Are you telling the users to store your addin in their xlstart folder?

If yes, then the users could have more than one (when you upgrade xl from
previous versions this can happen). I wouldn't be surprised if you have
multiple XLStart folders for each of your users.

If there aren't too many users, I'd do this:

open excel
hit alt-F11 (to get to the VBE)
hit ctrl-G (to see the immediate window)
type this and hit enter:
?application.startuppath

In win98 with xl2002, I get this:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

I wouldn't be surprised if winXP has profiles and "application data" in its path
to xlstart.

But excel tries to help you out by opening all the workbooks in all the xlstart
folders.

I'd use Windows start button|search (find??) to look for XLStart. Then move the
stuff that should be kept into the "real" startup folder (given in your
..startuppath test).

Then delete those older version(s) of XLStart.
 
Back
Top