View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Robinson Paul Robinson is offline
external usenet poster
 
Posts: 208
Default change a xla macro for a new version in XP

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

"Jalou" wrote in message ...
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