Thread: Excel VBA - COM
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
DaveThompson DaveThompson is offline
external usenet poster
 
Posts: 6
Default Excel VBA - COM

Hello all,

Thanks for your help, but the problem has now been solved by simply
changing the names of the new functions (by adding an extra character)
and then renaming all references programatically.

The problem with Excel "seeing" the old XLA hasn't been solved; the KB
article at http://support.microsoft.com/kb/286305/en-us ("PRB:
Automation Add-In Function Binds to Excel Built-In Function with the
Same Name") contains some pointers to the problem but annoyingly the
solution is simply to rename the functions.

Cheers all,

Dave