+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 20 of 20

Looking for a macro to open a pdf file based on a cell value please

  1. #16
    Forum Contributor
    Join Date
    11-03-2012
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2010
    Posts
    216

    Re: Looking for a macro to open a pdf file based on a cell value please

    Hi bakerman2, I am so sorry I posted the wrong code in the workbook this morning, please see new Revised Save2PDF file.
    I'm afraid I don't know what any of the code really mean, I can change the cell refs and file paths, that's about it.
    Attached Files Attached Files

  2. #17
    Forum Contributor
    Join Date
    11-03-2012
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2010
    Posts
    216

    Re: Looking for a macro to open a pdf file based on a cell value please

    bakerman2, mc84excel, I have actually got mc84excel's code to work this evening, have renamed all my files without the hyphens and removed the hyphens from the macro that saves to pdf from worksheet. I will do further checks before I mark thread as solved. Fingers x

  3. #18
    Forum Contributor
    Join Date
    11-03-2012
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2010
    Posts
    216

    Re: Looking for a macro to open a pdf file based on a cell value please

    bakerman2, Thank you for your help I have it sorted now with mc84excel's code. Thank you for your time.

  4. #19
    Forum Contributor
    Join Date
    11-03-2012
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2010
    Posts
    216

    Re: Looking for a macro to open a pdf file based on a cell value please

    mc84excel, Many thanks for your code, I now have it working. Much appreciated.

  5. #20
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,392

    Re: Looking for a macro to open a pdf file based on a cell value please

    You're welcome and thanks for rep+.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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