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
[Edit] You must activate the middle macro security
droplistmaker ;)
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 1
- Joined: Tue Oct 11, 2005 5:23 pm
pretty nice
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.
I didn't test this because I have excel in french and even excel formula are translated ( so weird lol ).
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);");")