Fixing Excel 2003 VBA that appears broken in Excel 2007

  • Thread starter Thread starter Jeroen Boot
  • Start date Start date
J

Jeroen Boot

I maintain a spreadsheet created by someone else that calls user defined functions.

Recenty I needed to migrate to Office 2007. All worked fine in xl2003, but xl2007 returns #NAME?.

Even this simple test fails:

Public Function testFunc(MyValue As Variant) As Variant
testFunc = "You gave me " & MyValue
End Function

Can someone give me a hint where to start ?

EggHeadCafe - Software Developer Portal of Choice
The XML I-Ching: Tao of the DOM
http://www.eggheadcafe.com/tutorial...054-6e21dad2bb96/the-xml-iching-tao-of-t.aspx
 
Did you put the code in a General module (not in a worksheet module, not in the
ThisWorkbook module)?

Did you remember to allow macros to run?
 
It works for me here when I do this

Sub test()
Debug.Print testFunc("value")

End Sub


What are you passing to it?
 
Back
Top