Thread: Determining File Size
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davidm davidm is offline
external usenet poster
  
Posts: 1
Default Determining File Size

:(
To calculate the size of a file, say, Tester.xls, we use:

Format(FileLen("Tester.xls")*0.0009767,"0") & "KB"

Can someone explain the use of the the factor* 0.0009767* (rather than
the customary .001) in converting the bytes into Kilo Bytes?


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=477045

Reply With QuoteReply With Quote