Excell and PDF Files
Use the hyperlink formula like this
=HYPERLINK("C:\Documents and Settings\username\Desktop\Test.pdf","Click to
Open TEST.pdf")
or insert a hypelink and navigate to the pdf file...
If Excel and PDF are in the same directory you can use
=HYPERLINK("Test.pdf","Click to Open TEST.pdf")
"Formula in Report" wrote:
I am using Excel 2003 and Adobe Standard 7.0
I am creating a price list in excel to be used on-line by our sales staff.
I want to add a link to our Co's sales literature pages that are PDF files.
The object being that when the sales person gives a quote over the phone to a
customer, they can also pull up a copy of the literature for more information
and/or also send the literature to the customer via e-mail if necessary.
This is not working. I created a sales literature folder in the same
directory as the excel file, with all of the literature. When I click on the
hyperlink in the Excel page, the screen flashes but nothing comes up. I know
that I can not bring up a pdf file in Excel or word for that matter but is
there a way to make this literature page available from a link in excel?
I would appreciate any help anyone can give me !!
Thank you - Aurora
|