Page 1 of 1

droplistmaker ;)

Posted: Sat Feb 04, 2006 10:56 am
by Yakup
I built into excel some macros and hereby can build drop lists one very fast.. Click Here

It is more comfortably as if you makes everything with a .txt file

aeh and in the file are still a few small descriptions^^
ask if you have some questions

hf and good luck :D

[Edit] You must activate the middle macro security

Posted: Mon Feb 06, 2006 5:46 pm
by shuma
pretty nice :D
juste a little modification in formula for SQL command, maybe you should add an ";" at the end of the line for proper SQL query, and put a round fonction for the chance to obtain only integer number.

Code: Select all

=CONCATENER("INSERT INTO droplist Values (";C13;",";D13;",";E13;",";F13;",";G13;",";Round(H13; 0);");")
I didn't test this because I have excel in french and even excel formula are translated ( so weird lol :shock: ).

Posted: Sun Feb 19, 2006 3:17 pm
by Yakup
hihi jo a litle mistake :P