tk102 Posted May 3, 2005 Author Posted May 3, 2005 There's probably some tricky technique of creating a hash table in Visual Basic for Applications to determine if values have already been written, but I haven't figured it out yet.
Shimaon Posted May 3, 2005 Posted May 3, 2005 Me love you long time. This ought to be very useful until we get copy and paste for multiple rows in KT. ^^ Thanks TK!
tk102 Posted May 4, 2005 Author Posted May 4, 2005 v1.2 Fixes a v1.1 bug regarding **** values that occurred if the first value in the 2da file was a ****. (Thanks Achilles) @Shimaon: Your welcome, but um, no thanks.
Achilles Posted May 4, 2005 Posted May 4, 2005 Thanks for fixing that! I just read and wrote appearance.2da again and everyone still has their weapons
tk102 Posted May 4, 2005 Author Posted May 4, 2005 v1.3 Astrisks are expanded by Excel's Find function, which was resulting in bad writes if the first value wasn't "****". A potential for bad writing exists if cells contain astrisks (other than "****" which is handled specially). See macro text for details.
tk102 Posted August 16, 2005 Author Posted August 16, 2005 v1.4 released Fixed a bug that was causing "Object Variable Not Set" in the Write2da function.
General Kenobi Posted August 16, 2005 Posted August 16, 2005 TK can you post up a linkie to your site??? I lost my favs in my 2000 to 2003 upgrade. Thanks a million for this one I'm gonna experiment with it on a new mod i'm working on General Kenobi
tk102 Posted August 16, 2005 Author Posted August 16, 2005 I don't really have a site other than starwarsknights.com unless you count my KeyTweak site.
Langy Posted August 16, 2005 Posted August 16, 2005 v1.4 released (8/25/05) Wow! It's a release from the future! That's absolutely amazing, man! In all seriousness, this macro kicks major ass. KOTOR Tool is horrible for editing 2DAs in any major way, and being able to edit them in Excel is amazingly useful.
cry_of_paine Posted August 20, 2005 Posted August 20, 2005 This is exactly what I was looking for. I did have to make one slight fix though. I put the routine into my personal.xls file, so that it's always available. So then the "ThisWorkbook" that you used to write the file gave me errors. I just changed that to "ActiveWorkbook" though, and it ran perfectly. I even gave it custom buttons on my toolbar to run it. You might think about doing all that and package it as an xla add-in (I'd tell you how if I could remember). Edit tk102: Thanks for the fix and good idea about the .xla -- now I'll have to see how that works.
tk102 Posted September 22, 2005 Author Posted September 22, 2005 v1.5 Released (Excel Add-In) - Now uses ActiveWorkbook rather ThisWorkbook in macro (as per above) - Distributed as an Excel Add-In (.xla) rather than a Module (.bas) file. 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.
Fred Tetra Posted September 23, 2005 Posted September 23, 2005 v1.5 Released (Excel Add-In) - Now uses ActiveWorkbook rather ThisWorkbook in macro (as per above) - Distributed as an Excel Add-In (.xla) rather than a Module (.bas) file. Excellent work!!! I was going to try setting it up as an XLA; thanks for saving me the time!
tk102 Posted September 27, 2006 Author Posted September 27, 2006 v1.6 released (9/27/06) - Eliminated need for tlbinf32.dll to be present on computer - Made 2da writing much faster
Ferc Kast Posted December 29, 2007 Posted December 29, 2007 For some reason, it won't allow me to write my 2da file at all from Excel. Could it be that I have 3 2da files open at the same time?
Gavroche Posted February 20, 2008 Posted February 20, 2008 Yep! I had a quick question about this add-in, is there any chance that it would be compatible with OpenOffice Calc? I guess I could just use the GFF<->XML conversion utilities (as far as I remember, .2da are gff files, aren't they?) and then open the .xml with OpenOffice... Anyway, I'm wondering. <edit />Nope, it seems the GFF<->XML tool won't work with .2da. Well, now I hope somebody will come up with an answer "^^
Darkkender Posted February 20, 2008 Posted February 20, 2008 2da files are 2da files. 2da stands for "Two Dimensional Array". GFF files are a generic file format that handle a variety of different ingame objects such as characters, doors, waypoints, items, placeables, encounters, & more. GFF stands for "Generic File Format". This macro download simply converts the 2da file into an excel spreadsheet since a 2da is a simple spreadsheet. Meanwhile your GFF files are a more complex structure based file with nodes and subnodes withing the structures.
tk102 Posted February 20, 2008 Author Posted February 20, 2008 @Gavroche: stoffe asked the same thing about Open Office support. At some point I should try out Open Office and take a look at what macro support is offered. Unfortunately, the XLA isn't handled as-is.
Ray Jones Posted February 20, 2008 Posted February 20, 2008 Open Office has macro support, some own Open Office Basic and Python based AFAIK.
Gavroche Posted February 20, 2008 Posted February 20, 2008 @Darkkender: Ok, thanks for the informations. Quite interesting, though it's no good news for me "^^ @tk102: Yes, I just tried and got kicked out by OOCalc Thanks anyway for the answer.
JCarter426 Posted May 31, 2008 Posted May 31, 2008 Hmm...I'm guessing it doesn't work with Excel '07. Or if it does, then I fail miserably.
Master Zionosis Posted June 3, 2008 Posted June 3, 2008 Hmm...I'm guessing it doesn't work with Excel '07. Or if it does, then I fail miserably. I've come to the conclusion that it does not work, after about half an hour of trying, shame... Maybe tk will release an update... But then again, maybe not... lol.
Master Bacon Posted August 5, 2008 Posted August 5, 2008 Is there a manual or a how to merge two 2da files with Tk102's ingenious mod? Or am I in the wrong place?
ChAiNz.2da Posted August 6, 2008 Posted August 6, 2008 Is there a manual or a how to merge two 2da files with Tk102's ingenious mod? Or am I in the wrong place? For merging purposes, stoffe's 2DA Converter/Merger Tool might be an easier solution for you
Recommended Posts
Archived
This topic is now archived and is closed to further replies.