J-Walk & Associates, Inc.

Problems With Euro Currency Tools Add-In

If you're experiencing some inexplicable errors with your VBA code, check your add-ins list (press Alt+TI). If Microsoft's Euro Currency Tools add-in is installed, uninstall it. That add-in should be banned. Euro Currency Tools is the only add-in I've seen that can cause errors in VBA code that's in a completely different workbook.

Try this in Excel 2007...

First, make sure the Euro Currency Tools add-in is installed. Activate a worksheet that has a few formulas, and then run this macro:

Sub TestEuroTool()
  Dim WorkRange As Range
  On Error Resume Next
  Set WorkRange = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas, 23)
  Debug.Print WorkRange.Count 'formula cells
  Debug.Print Err.Number, Err.Source
End Sub 

Err.Number should be 0, since the sheet has formulas. But it's 9 (Subscript Out of Range), and the source of the error is Euro Tool (the name of the VBA project in EUROTOOL.XLAM) . At least a dozen PUP users have notified me of an error -- and uninstalling the Euro Currency Tools add-in fixes the problem.

It seems to be fixed in Excel 2010 beta.

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By WhyBe. Comment posted 29 April, 2010 5:54am

   even more simple, try this macro :
   
   

   [b]Workbooks.Open Filename:="C:\Program Files\Microsoft Office\Office12\1033\VBALIST.XLS", ReadOnly:=True
MsgBox Err.number
Workbooks.Open Filename:="C:\ToSeeDifferenceWhenRealError.xls", ReadOnly:=True[/b] 

   
   
   (verify first if the file I use really exist on your computer)
   
   Surprise !!
   Err is not Zero anymore, but the macro is still running normally...
2. By PaperBeetle. Comment posted 23 September, 2010 8:11am

   Yep, I get that. I think all that's happened is that EuroTool has thrown an error for its own benefit, and handled that error, but has omitted to use

   err.clear 

   once it is done handling.
   It's pretty lame that this add-in is costing us debugging time, and depending how you like to handle your errors, you might have to code around this one. But at least there isn't actually anything real going wrong with your code...
3. By PerHogan. Comment posted 18 January, 2011 3:31am

   i lost 2 days to understand the issue...
   the weird thing is that it worked fine till the day before...