View Single Post
  #13  
Old December 9th, 2002, 01:18 AM
Ed Kolis's Avatar

Ed Kolis Ed Kolis is offline
General
 
Join Date: Apr 2001
Location: Cincinnati, Ohio, USA
Posts: 4,547
Thanks: 1
Thanked 7 Times in 5 Posts
Ed Kolis is on a distinguished road
Default Re: Modding tools: Access vs. Excel

OK, here's the spreadsheet... currently I only have a worksheet for the weapon mounts, but if you change the column headings and the name of the file being read in the macro then you can read any SE4 data file...

www.geocities.com/edwardkolis/se4/SE4ModderWorkbook.zip (11 KB)

Don't forget to set cell A1 in the "Path" worksheet to the path of your data files, otherwise you'll probably get bunches of errors

I'm probably going to rework this, though, since I realized it won't work for things like the weapon damages where there are really 20 entries in one, and the way I handled the "array" entries (like tech requirements and such) is not optimal - if there are more than 10 (or however many you make headings for) it just ignores the rest...
__________________
The Ed draws near! What dost thou deaux?
Reply With Quote