Display text link to open specific PDF page from Excel

excel vba pdf excel-2003
Fiona picture Fiona · Dec 2, 2010 · Viewed 9.9k times · Source

I found a VBA code online that opens up an internal (shared drive) PDF document page in IE (e.g. goes to page 8 of PDF file). I would like to display text in the cell for a user to click (e.g. "Click here to view").

Problem: The cell currently displays '0' and I have to go to the function bar and hit [Enter] to execute.

Excel Version: 2003

Function call:

=GoToPDFpage("S:\...x_2011.pdf",8)

VBA Code:

Function GoToPDFpage(Fname As String, pg As Integer)
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Navigate Fname & "#page=" & pg
.Visible = True
End With
End Function

:EDIT:

I was able to display text, but it's still not a link like I wanted.

="Click to view" & GoToPDFpage("S:\...x_2011.pdf",8)

Thank you for your help.

Answer

CaBieberach picture CaBieberach · Dec 3, 2010

Try Menu->Data->Data Validation. In the 2nd tab you can write your message.

Related questions

Exporting an MS Excel 2003 workbook to PDF via VBA

I have an Excel 2003 workbook that contains a macro to copy certain of its sheets across to a new workbook, then save and close the new workbook. It does this several dozen times, with slightly different sheet selections each time. …

Read More
VBA Print to PDF and Save with Automatic File Name

I have a code that prints a selected area in a worksheet to PDF and allows user to select folder and input file name. There are two things I want to do though: Is there a way that the PDF …

Read More
Save multiple sheets to .pdf

I have a reporting spreadsheet that grabs some data from a database and forms three sheets of summary report information. I want to run the spreadsheet automatically from the command line, and have it automatically save all three reporting sheets …

Read More