+ Reply to Thread
Results 1 to 5 of 5

Excel data MACRO to PDF Form

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    75

    Excel data MACRO to PDF Form

    Hi guys

    I have tried searching for this on t'internet but every forum seems to go down a slightly different path to what I need.

    I have a spreadsheet that users enter information into to create a price.

    I need to transfer that price (and a couple of other bits of information, name, type, etc.) into a PDF form which I have already created as a fillable PDF using Acrobat Pro.

    I'm after a macro within Excel which will let the users do this automatically.
    • I cannot use anything within Acrobat Pro, as the users dont have this
    • I dont want any third party software
    • I dont want to do it all in Excel and SAVE AS PDF as excel design is crap

    Can you help?!?!?

    Ta

    SD
    Cry Havoc, let loose the Dogs of War

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Excel data MACRO to PDF Form

    I dont want to do it all in Excel and SAVE AS PDF as excel design is crap
    Then why are you asking here ?

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Excel data MACRO to PDF Form

    LOL, dont be pedantic!

    I don't want to design the form within Excel and SAVE AS PDF. I want Excel to do the calcs and then export into a precreated PDF form that looks posh!

    Hope that makes sense.

    Thanks

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

  5. #5
    Registered User
    Join Date
    10-10-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Excel data MACRO to PDF Form

    Seems like this cant be done without the other users having a copy of Acrobat Pro - Damn!

    Thanks for the references anyway.

    SD

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Office 2010: Transfer Form Content Control Data into Excel Database - Macro Help
    By Maredon2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2016, 03:45 PM
  2. Using VBA to transfer data from Excel form to a web form. error 'Permission Denied'
    By danieldowds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2014, 08:14 AM
  3. Replies: 56
    Last Post: 03-11-2014, 03:56 PM
  4. Replies: 1
    Last Post: 02-28-2013, 08:17 AM
  5. [SOLVED] Excel macro to extract Word form data into Excel
    By Phillipe in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-01-2012, 10:55 PM
  6. [SOLVED] Macro to collect data from Excel Form and populate multiple tabs
    By kande in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-26-2012, 11:15 AM
  7. Data Entry Form (similar to default Excel Data>Form)
    By tonydm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 02:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1