field in word from excel
Hello all,
I am looking for a way to add a field in Word with information from a Excel file.
I already found out how to import the whole thing, but that is not what I want.
I want to be able to get just 1 cell with only that information.
To maybe explain myself better I can describe why I want to use it.
I want to make a template in Word with multiple fields with information from excel. Best would be to have one "master" field in Word where I can choose the customer information from.
The other fields should then change their received information based on the master value.
I know I can do this in excel, but Word would be better. I do not really trust the users in excel. So if I seperate it as front-end back-end I feel more secure with the data.
Thanks in advance
P.S.
I looked a bit and found this code for a field:
DATABASE \d {...} \s "SELECT * FROM `Sheet1$`" \h
Where {...} is filled with information, but this is easier to read.
Now I want to select indeed certain things from that sheet.
Lets say I want to select only field A2. How can that be accomplished?
P.P.S.
Got it done. \s "SELECT * FROM `Sheet1$A1:A10` WHERE Nummer = 1" will only return the nummer 1. That is good.
But I can only do this with A1:A10.. not with the B column. So still not done with this part xD
But now I need some way to change the values from nummer = x. So that when I change x, the rest of the document will change (when I CTRL A, F9 it)
Last edited by Evolta; 11-11-2013 at 09:00 AM.
|