Thread: return text not index for property
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicky[_16_] Nicky[_16_] is offline
external usenet poster
  
Posts: 1
Default return text not index for property

Hi all
A simple question, I hope
how do I return the name rather than the index number for a property,
so that eg

MsgBox ActiveWorkbook.FileFormat

returns "xlWKS" not "39"


--
Nicky


------------------------------------------------------------------------
Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
View this thread: http://www.excelforum.com/showthread...hreadid=380800

Reply With QuoteReply With Quote