>>Here's a funny one. No biggie but a bit annoying.
>>
>>I use the following code to generate a fairly unique filename for my exported XLS file, incorporating today's date + a random no. suffix, in case several XLSs are generated in one session/day, so they don't need to keep typing in a new name. This has been working fine till today. But today it keeps giving 851 and 856 (and others similar) off my m/c AND the 2 users' m/cs, such that my code, and Excel's interface keep asking if want overwrite.
>>
>>

>>lcRandNum	  = ALLTRIM( STR( INT( RAND() * 1000)))
>>lcDateStr	  = ALLTRIM( DTOC( DATE()))
>>lcDateStr	  = STRTRAN( lcDateStr, "-", "_") + lcRandNum
>>lcFilePath = PUTFILE("Export Results", "S" + lcDateStr, "XLS")
>>

>>
>>Both when testing and today I've been issuing:
>>
>>? STR( INT( RAND() * 1000))
>>
>>repeatedly at the command line with expected varied results. Any ideas?
>>
>>'ppreciate it
>>
>>Terry
>
>Ok, out of pity: Re: Unable to get random generation with OleDb Thread #1154512

Beat me but don't pity me. Yes I figured it out after your last teasing answer.

I guess I just got out of the practice of seeding randomly as in my youth :-)