Hi Lew,
We can 'cut and paste', but still can't
insert/embed a whole Word or Excel document without it
expanding.
My ignorance is showing, how is that different?
You "embed" something via the Insert/Object menu, and this
essnetially inserts a graphical object (when you click on it,
you get "handles" around the outside, as with an picture).
What you can do with graphical objects in a form, even in an
unprotected section, is limited.
If you copy/paste from an Excel sheet or another Word
document, you aren't embedding, you're "inserting". And
usually Word will treat the result like part of its own
document text. This means the user should be able to work
with it without too many problems, in an unprotected section.
To save time/effort from having to recopy into a field. A
description field may have a supporting document and it is
easier to include the original document/spreadsheet than
retype.
OK, let's see if I understand, now:
- you have a document protected as a form, with text form
fields
- the users would like to insert text from existing files
into these form fields. And they'd like to use Insert/File, I
take it?
- they'd also like to insert spreadsheet tables? Form fields
won't accept these at all, when protected
For insert/file, you could use macro code that basically:
- unprotects
- displays the Insert/File dialog box so the user can select
- reprotects
You'll find the basic unprotect/reprotect code you need on my
website. For the other, try:
Dialogs(wdDialogInsertFile).Show
Note, however, that the user will have to type SOMETHING into
the form field, then have the cursor blinking, otherwise
they're likely to delete the form field when inserting.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail