View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Olmsted Tom Olmsted is offline
external usenet poster
 
Posts: 1
Default Rnd function used in VB on network

I'm using RND and Randonize statements in VB appications
in Excel workbook. It works on my system but if any other
use access this file on my c: drive it doesn't reset the
randon sequence. So every time they open the workbook it
generates the same randon numbers. I am using the Ranonize
statement with on number option.