Thread: Value Metadata
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IgorM[_2_] IgorM[_2_] is offline
external usenet poster
 
Posts: 41
Default Value Metadata

Hi

How can I check (using VBA) if a cell has some metadata associated (as
described he http://msdn.microsoft.com/en-us/library/dd953161.aspx).
I ask because I have an xlsx file with data that when opened in Excel 2007
shows values only. But when I save the same file in xls format and open it
in Excel 2003 it displays value in the cell but in formula box Excel shows
_xlfn.COMPOUNDVALUE(20) for instance.

Thanks
IgorM