Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Hyperlink in excel

  • 16-08-2014 10:33AM
    #1
    Ch1986
    Registered Users, Registered Users 2 Posts: 14 ✭


    Hi there,

    I am working on a application form on excel and I am trying to have a tile in my excel sheet that would generate a pfd version of this form upon a click.

    I'd like to make this form as user-friendly as possible and would like to have the user to have to go to the traditional "file, save, publish PDF"


    I don't know if this is something feasible, anyone has an idea or could help with this would be very appreciated.

    thanks a lot.


Comments

  • #2
    gleesonger
    Registered Users, Registered Users 2 Posts: 166 ✭✭gleesonger


    Not a hyperlink but a Macro button can do this.
    Look into how to place a button on the page and how to saveas using VBA.
    There should be plenty of code online linking the two.

    There is a way you could do this using hyperlinks but it would involve launching externally written code which would then load the Excel com object and access the active workbook/sheet most probably not something you want to do.


    Save as PDF:
    http://stackoverflow.com/questions/20750854/excel-vba-to-export-selected-sheets-to-pdf


Advertisement