Consulting

Results 1 to 3 of 3

Thread: Hyperlink Problem when print Excel to PDF

  1. #1
    VBAX Newbie
    Joined
    Aug 2009
    Posts
    2
    Location

    Hyperlink Problem when print Excel to PDF

    Hi, everyone.
    I'm using VBA to print excel workbook to pdf. Everything goes fine except that all the hyperlinks are gone. But there is this one workbook that when I print it, the hyperlinks are preserved. I tried to print it with sereval PDF printers, and got the same result - the hyperlinks are there. But no luck with other workbooks. It's really a myth to me cause it doesn't make sense. I tried to demystify this magic by myself but with no luck. Hopefully someone here can help me out. I believe there must be a rational explanation for this . Here I attached the workbook so you guys can analyze it.
    My environment is Win7 RC(English version) + Office 2007 Home and Student(Chinese version, the interface is in English though which seems odd to me).

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Location
    Nanaimo, British Columbia, Cananda
    Posts
    568
    Location
    Hi,

    Maybe an example of the code you're using as well?
    Cheers,

    dr

    "Questions, help and advice for free, small projects by donation. large projects by quote"

    http:\\www.ExcelVBA.joellerabu.com

  3. #3
    VBAX Newbie
    Joined
    Aug 2009
    Posts
    2
    Location

    About the code I used

    I only use the PrintOut method of the WorkSheet object with all the default arguments. Nothing special. The code is like this
    sheet.PrintOut

    I don't know. There must be a bool value or that sort of thing to control whether print Hyperlinks or not but the problem is that I can't find it.

Posting Permissions

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