SuperKees
08-16-2010, 06:30 AM
Dear all, I wish to push data from excel to word.
starting with a list of (named) values in excel, I wish to run a macro (from excel) that loops over each cell in a particular range
the macro should then:
checks the name of cell
if equal to a identfyer (bookmark / field / whatever) in word
push value & ( restore identifyer)
search for next Value in word until all found
start with new excel value and loop
The problem is that the wordfile itself is the result of a macro that combines multiple source documents. The source documents should containt identical identifyers (for example field or bookmark) (for example CUSTOMER_NAME) and each CUSTOMER_NAME identifyer should be replaced with the corresponding value from excel (a named range for example)
my problem is that multible identically named bookmarks are impossible (annoying ???) and that when i use fields don't know what type to use or how to loop over them (checking for existance) and replace all identical onces with the same source value.
I prefer not to use a search and replace of normal text
I aapriciate any help! thnx in advance!
starting with a list of (named) values in excel, I wish to run a macro (from excel) that loops over each cell in a particular range
the macro should then:
checks the name of cell
if equal to a identfyer (bookmark / field / whatever) in word
push value & ( restore identifyer)
search for next Value in word until all found
start with new excel value and loop
The problem is that the wordfile itself is the result of a macro that combines multiple source documents. The source documents should containt identical identifyers (for example field or bookmark) (for example CUSTOMER_NAME) and each CUSTOMER_NAME identifyer should be replaced with the corresponding value from excel (a named range for example)
my problem is that multible identically named bookmarks are impossible (annoying ???) and that when i use fields don't know what type to use or how to loop over them (checking for existance) and replace all identical onces with the same source value.
I prefer not to use a search and replace of normal text
I aapriciate any help! thnx in advance!