tk102 Posted April 22, 2005 Posted April 22, 2005 v1.6 released (9/27/06) - Eliminated need for tlbinf32.dll to be present on computer - Made 2da writing much faster v1.5 (add-in) released (9/22/05) - ThisWorkbook changed to ActiveWorkbook - Distributed as .xla http://www.starwarsknights.com/tools.php Instructions 1. Unzip the .xla file to wherever you like. Open Excel. Choose Tools: Add-Ins. 2. Browse to the .xla file. 3. Make sure the new Add-In is checked and click OK. 4. You can now Read 2DA and Write 2DA files using the File menu.
Mav Posted April 22, 2005 Posted April 22, 2005 WOW this is definetly going to help with .2da editing, awesome job tk!
RedHawke Posted April 22, 2005 Posted April 22, 2005 Very, very nice tk! This will definately help when doing massive 2da edits.
General Kenobi Posted April 22, 2005 Posted April 22, 2005 Ooh so sweet big T thanks man ! I love using Excel for stuff since I use it for most anything else table related. I'm gonna play with this when I get home. Maybe this will aid me in going forward on a project I'm working on.
Achilles Posted April 22, 2005 Posted April 22, 2005 Chainz.2da is gonna be lovin' you. Excellent work on this!
ChAiNz.2da Posted April 22, 2005 Posted April 22, 2005 Originally posted by Achilles Chainz.2da is gonna be lovin' you. Excellent work on this! Ahh....yeah... it's all goooood
Bob Lion54 Posted April 22, 2005 Posted April 22, 2005 ^^^^^^ Yea, but it was made AFTER the HUGE .2da conversion. Great tool!!! I think "tk" should stands for "Tool Kreator."
Darkkender Posted April 22, 2005 Posted April 22, 2005 which version of MS excel will this be compatible with TK? Just a slight curiosity as I use an older version and some macros work and others don't. I know I can import them though.
SoNico717 Posted April 22, 2005 Posted April 22, 2005 Great Job TK102, this is really usefull. Thanks for sharing this with us .
tk102 Posted April 22, 2005 Author Posted April 22, 2005 Gee, I had no idea so many people would use this. I made it just to see if I could since I've been programming Excel macros lately. Darkkender, I think it should work with Excel 97 and later. The Write function, you'll notice, is significantly slower than KotOR Tool, so if anyone can come up with some optimizations to the macro code, feel free to post them.
Daiko701 Posted April 22, 2005 Posted April 22, 2005 I am recieving an error when trying to run the write function macro as follows: Microsoft Visual Basic: ------------------------ Run-Time error '53': File not found: TLBINF32 ------------------------ I am using Microsoft office 2000 Premium (Excel) with SR-1. I can open the .2DA files but when I try to write them I recieve the error as mentioned above. My Sys Specs: Win XP Home SP2 AMD Athalon 2200+ 1.8 GHz 512 MB DDR SDRAM ATI 9550 128 bit 256 MB (Bios flashed to 9600 Pro 256 MB) SB Audigy 2 LE 24 bit sound All Latest updates for all. I would love to be able to use this tool, yet I do not know why I am experiencing this. Any ideas, suggestions? Edit*BTW great work on the tool, and thanks. Other than above it is superb.
Achilles Posted April 22, 2005 Posted April 22, 2005 I'm getting it too (already sent my specs to Tk102), but I'm not too worried about it. Even though you get the error, the macro appears to be saving the changes. All's well that ends well I guess
Jeff Posted April 22, 2005 Posted April 22, 2005 This is sweet TK! Good job, I love all the programs you make. Keep up the good work!
L33T-THX-1138 Posted April 23, 2005 Posted April 23, 2005 it seems easy enough to figure out but,i dunno where to get this "excel" from n e help would be much helpful thanks in advance
General Kenobi Posted April 23, 2005 Posted April 23, 2005 Originally posted by L33T-THX-1138 it seems easy enough to figure out but,i dunno where to get this "excel" from n e help would be much helpful thanks in advance Microsoft Excel (Usually contained within Microsoft Office)
tk102 Posted April 23, 2005 Author Posted April 23, 2005 TLBINF32.dll is normally found in your C:\WINDOWS\SYSTEM32 or C:\WINNT\SYSTEM32 folder. Do a search for that file. If you find it, try this (from your taskbar) Start: Run: regsvr32 tlbinf32.dll If you're getting the error, I wouldn't expect the .2da file to be written correctly.
tk102 Posted April 23, 2005 Author Posted April 23, 2005 Here is a download link for tlbinf32.dll if you don't have it. http://www.ezgoal.com/dll_files/tlbinf32.zip Unzip the .dll to your System32 folder and do the regsvr32 command as mentioned in the previous post.
Daiko701 Posted April 23, 2005 Posted April 23, 2005 Thank you so much tk102, the tool works great. You provide better support than Microsoft lol. Beauty of a program you have made here. Now it should be easy as 1-2-3 to make all of the mods I use compatible (finally, whew).
Darkkender Posted April 23, 2005 Posted April 23, 2005 Originally posted by tk102 Darkkender, I think it should work with Excel 97 and later. :elephant: How did you know that was the version I used. I personally like this for 2da's as I've started taking an interest in NWN modding or more in particular getting the hang of how they mod around some of the hardcoded elements. I'm starting to think with the proper usage of scripting we can write our own include files that provide the ability to use custom 2da files. Also I would be interested in figuring out how the game would recognize ".HAK" files and having them in the proper overide system. If we can do this it may take KOTOR I & II modding to a whole new level.
stoffe Posted April 23, 2005 Posted April 23, 2005 Originally posted by Darkkender I'm starting to think with the proper usage of scripting we can write our own include files that provide the ability to use custom 2da files. I doubt this is possible in KotOR beyond altering the 2DA files already used by some scripting functions. Unfortunately the Get2DAString() function in NWN NWScript is not present in the KotOR variant. NWScript has undergone a fair number of changes in the NWN --> KotOR transition. Originally posted by Darkkender Also I would be interested in figuring out how the game would recognize ".HAK" files and having them in the proper overide system. If we can do this it may take KOTOR I & II modding to a whole new level. Unless you are making your own modules, using hakpaks would be of limited use, since they need to be specified for each module that use the content within them. The hakpak filename has to be set in the Mod_Hak field in the module.ifo file for all modules using it. They don't work on the global scope like the Override folder does. Provided that the hakpak functionality still remains available in the KotOR engine, that is. I haven't tested it. (Hakpaks are the preferred means in NWN of storing custom content (models, tilesets etc) associated with specific individual modules. They are essentially just ERF files with a .hak suffix placed in the "hak" folder.)
tk102 Posted May 3, 2005 Author Posted May 3, 2005 v1.1 Made some small tweaks to the macro to get it to write appearance.2da without crashing. (Thanks for bringing that to my attention Achilles.) It's still takes my PC about 100 seconds to write the whole thing. Also added a little progress notification in the status bar of Excel during writing, and a Freeze Panes (for column and row headers) after a Read.
Xcom Posted May 3, 2005 Posted May 3, 2005 Originally posted by tk102 It's still takes my PC about 100 seconds to write the whole thing. I wonder if that's due to the fact that it's a macro, or because it's Visual Basic? I don't have Excel on this rig, so I can't give it a spin, but I've been working on my own, automatic 2da merger, and it's pretty fast when writing (well, about the same speed as Fred's 2da editor), so I guess it's macro thing.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.