>>>>>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
>>>>
>>>>uses RAND() for this task is wrong.
>
>Thanks Tore but it's not exactly a very meaningful name, is it? - like telling the user the date he/she made the file. :-)
I did not bother to read the whole thread, just the sentence "It's just a cheap & cheerful way of generating a (fairly) unigue file name"