View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry Zhang Terry Zhang is offline
external usenet poster
 
Posts: 1
Default excel 2007 UDF name problem

I insalled the Office 2007 from MSDN subscription, and find a strange
behavior that doesn't occur at Office 2003.

If I define a User Defined Function (by VB macro) with name like 'qAB01',
wherever I typed "=qAB01()' in a formula bar for a cell, the formula will be
auto-changed to "=QAB1()". This results in a #REF error.

Addtionally, I find that I can not register a UDF with name 'qAB01' too
through XLL C API too.

Thanks,