Results 1 to 6 of 6

Thread: Forms (2000)

  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms (2000)

    Greetings -

    I want to create a form differently than I have before. I would like to have 3 or 4 text fields on it and then be able to copy and paste rows of info one at a time from an Excel spreadsheet onto that form.

    I've tried creating a text field and pasting into it but it does not hold the spreadsheet formatting as a simple copy and paste does.

    Can this be done? Part form, part Word page? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (2000)

    I don't think you can do it using a FormField. Pasting into a formfield is like using Paste Special Unformated Text. The limited amount of formatting that can be done with the field is done by setting the field properties, using formatting switches, or applying direct formatting to the field.

    Have you considered using an INCLUDETEXT field to pull in ranges from Excel? Or, you could unprotect sections in the Word document & paste the spreadsheets in the unprotected section.
    Cheers,

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (2000)

    Phil!
    That part about unprotect part of the Word doc - let's see if I understand you because that sounds like what would work very well.

    Bear with me - here's one thing I did along those lines -
    1) I open a new Word Doc
    2) I type text that will be part of the form
    3) I insert checkboxes and text fields where desired
    4) I protect the document and save it as a template.
    Problem - Now I can't paste anything into that page and I want to.

    How would I unprotect part of that one page template so I could paste what I wanted from Excel and have it keep its' format?

    Thanks as always! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (2000)

    I'm sorry. I should have been more specific, but I wasn't sure if this would suit your purpose. What you do is insert continuous section breaks (easiest in normal view). You could insert New Page section breaks, if you wanted. Either way, when you go to Tools/Protect Document..., the dialog box will open & there is a button that says "Sections". Click it & you'll be able to choose which sections you want to protect. Even after you protect the document, you can type & paste in those sections that aren't protected.

    Post back if this isn't clear. <img src=/S/nosleep.gif border=0 alt=nosleep width=27 height=15>

  5. #5
    Star Lounger
    Join Date
    Mar 2002
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (2000)

    Phil -
    So sorry - I don't know what I'm doing right and what I'm doing wrong! Please see attached. Thanks!
    Attached Files Attached Files

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (2000)

    <P ID="edit" class=small>(Edited by Phil Rabichow on 12-Nov-02 18:09. Forgot attachment)</P>I've modified your document & attached it. Your picture should be pasted inline or else your going to have trouble with it moving. You can put text in directly or in a table cell.

    However, Word has no intrinsic way of creating the next page with 2 section marks each time. What I would do is create a template for this project. I would create an autotext entry that consists of a continuous section break, your formfields, & then a next page section break. Then you can paste your picture, insert your autotext & continue.

    However, I think it would be best to have a macro that went through & protected the document for the even numbered sections. I don't know how to do that, but maybe one of the VBA experts could. I'm still not sure whether you would be protecting the document as it developed or after it was all over.

    Hope this helps,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •