|
|
|
|
 |
December 19th, 2002, 06:25 AM
|
 |
General
|
|
Join Date: Nov 2000
Posts: 3,013
Thanks: 17
Thanked 25 Times in 22 Posts
|
|
Re: Modding tools: Access vs. Excel
Quote:
Originally posted by Andrés Lescano:
I use Excel and Word to mailmerge into se4 data files.
|
I'm wondering how you go about getting the data from Excel into the data source for the mail merger? I've got a whole bunch of components designed in Excel and it would be great to be able to keep their relationships automatically adjusted whenever I make a change to the base component. |
December 19th, 2002, 05:47 PM
|
 |
Private
|
|
Join Date: Mar 2001
Location: Layton, UT
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
Quote:
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 tried to retreve the spreadsheet but I get
Quote:
|
Sorry, the page you requested was not found.
|
|
December 19th, 2002, 07:50 PM
|
|
Major
|
|
Join Date: Apr 2001
Location: Rosario, Argentina
Posts: 1,047
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
|
January 1st, 2003, 02:49 AM
|
 |
First Lieutenant
|
|
Join Date: Sep 2001
Location: Edmonton, Alberta, Canada
Posts: 738
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
bump!
I'm going to try out Andre's system, but I'd love to use the other also. Is Jan 8th still on the go?
__________________
Jimbob
The best way to have a good idea is to have lots of ideas.
-Linus Pauling
Take away paradox from the thinker and you have a professor.
-Søren Kierkegaard
|
January 3rd, 2003, 05:35 AM
|
|
BANNED USER
|
|
Join Date: Nov 2001
Location: Near Boston, MA, USA
Posts: 2,471
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
Hm, Jan 8th. I think on a PERT or GANT chart it is called, "Slippage". Lets see what I can pull off this weekend.
|
January 3rd, 2003, 09:31 PM
|
|
Private
|
|
Join Date: Mar 2001
Location: Layton, UT
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
Bump 
Quote:
quote:
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 tried to retreve the spreadsheet but I get
Quote:
|
Sorry, the page you requested was not found.
|
Would you please repost this spreedsheet. |
January 4th, 2003, 12:43 AM
|
 |
General
|
|
Join Date: Apr 2001
Location: Cincinnati, Ohio, USA
Posts: 4,547
Thanks: 1
Thanked 7 Times in 5 Posts
|
|
Re: Modding tools: Access vs. Excel
Oh, all right... I thought I did but I'll try again, let's see if Spaceports supports remote linking...
http://galileo.spaceports.com/~ekoli...erWorkbook.zip
__________________
The Ed draws near! What dost thou deaux?
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
