Results 1 to 2 of 2

Thread: Converting Excel Files to Adobe Forms
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Converting Excel Files to Adobe Forms

    I have a spreadsheet that I customize, then convert to an Adobe form, then send out to people outside my organization to fill out and return to me. We then enter their info back into the master spreadsheet.

    I save to PDF, then have Adobe convert it to a form. Generally, everything populates as it should, but a bunch of the cells don't left justify properly.

    I am not sure if this is an Excel issue or an Adobe issue. Thoughts?

    Also, as I write this...I am wondering if it makes more sense for me to add protection to the spreadsheet, and email it to them. I just want them adding rows and changing data without me realizing it.

    Thanks in advance!

  2. #2
    Board Regular
    Join Date
    Mar 2010
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Excel Files to Adobe Forms

    I think I might change things up and send them the excel spreadsheet.

    I'll set up protection to prevent unwanted modifications to the SS.

    It would look something like this....

    1. I edit a worksheet and get it ready to go out to people.
    2. Then I would copy that spreadsheet into a new Excel file (there are other worksheets in the workbook that i can't share).
    3. Then add protection to the worksheet.
    4. Then email it to them.

    Thoughts on how to write this macro? And how would it be activated? Could I put t button on the sheet to activate the macro...but the button would not copy over with the worksheet to the new workbook?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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