JezCottrill
New Member
- Joined
- Nov 5, 2013
- Messages
- 1
Hi,got a real head scratcher here. I have created a protected userform template in word and it works just great but I also want to enable e user to open up an Excel document (currently on a networked folder - but could be put onto the same harddrive and for the user to be able to select various data fields and for the data to either automatically populate the blank entry points in word.
ideally I think the solution is to have a series of macros in the word doc that will in some way enable the next clicked data in excell to be automatically copied and pasted into the field in word.
tried mail merge but apparently it doesn't work in a protected word form and am only left with a laborious cut and paste for numerous fields unless it can be automated in some way.
Any clues.
i can email the doc and spreadsheet if it helps. Oh and yet he way currently developing it on a 2003 ms office platform but needed for a 2010 version.
Told you it wasn't an easy one.
ideally I think the solution is to have a series of macros in the word doc that will in some way enable the next clicked data in excell to be automatically copied and pasted into the field in word.
tried mail merge but apparently it doesn't work in a protected word form and am only left with a laborious cut and paste for numerous fields unless it can be automated in some way.
Any clues.
i can email the doc and spreadsheet if it helps. Oh and yet he way currently developing it on a 2003 ms office platform but needed for a 2010 version.
Told you it wasn't an easy one.
