Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Hyperlink in excel

  • 16-08-2014 9: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