Generate a 6 digits code based on filename and time of generation?

Unfortunately, I don't think so.

The "Master file" will be used by all my colleagues to generate our local pricelist, selecting their own template on their own computer.
Hence why I was thinking of using the template filename and the date/time to generate a unique string

Ok, I found a quite easy way to hash the filename

Please Login or Register  to view this content.

The results are always using [A-Z] in the following format:
W-JMYAIK
W-IBPTEN
W-YOYCCE
W-EAGHDF

But now, I struggle to enter the UNIX timestamp to generate a unique quote number.
If I use a function in a cell, it works great:
=Quote(CONCATENATE("N:\Flash Memory\Volume pricing\Templates\England.xls",TEXT( NOW()*86400-DATE(1970,1,1)*24*60*60,"0000000000")))
where the concatenation gives the following result N:\Flash Memory\Volume pricing\Templates\England.xls1250790305

So ideally, I need to modify my quote function to simply use as follow:
= quote("N:\Flash Memory\Volume pricing\Templates\England.xls")
and it automatically adds the UNIX timestamp within the script

Please Login or Register  to view this content.

Any idea on how to add this bloody timestamp and concatenate it to the text variable

Thanks in advance for any pointer/solution/etc.
Ludo

Originally Posted by Phil_V

Let me know how this works out for you:

Please Login or Register  to view this content.

Thanks a lot Phil.

I will have to wait tomorrow to test it once I'm at work as I only have Linux computers at home but looking at the code, it does seem to do exactly what I am after!

Cheers,
Ludo

Originally Posted by Leith Ross

Hello Coume,

Here is another method. It creates a six digit hew value using the current date and time. Since this a UDF, you can use this on a worksheet as well.

Please Login or Register  to view this content.

Hello Leith,

Thanks. That's an interesting code.

I will have to think on how I could mix the time with a string (filename) and still be able to generate a 6-digit result but that will wait tomorrow back @ work

Thanks
Ludo

Originally Posted by Phil_V

Please Login or Register  to view this content.

Morning Phil,

After testing, it does not work.

Every second when you generate the timestamp, the result should be different, but it always gives me the save result 1250812800

This script did not consider the hour/min/sec and it was outputting Today's UnixStamp.

Yesterday result was 1250726400 so if you add 24h x 60 min x 60s (86400); it gives the above result 1250812800

So after a bit of tinkering, here is a working one for anyone interested

Please Login or Register  to view this content.

Thanks
Ludo