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

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

Thank you for answering my call for Help - but I could not get your formula
to work.
I put in the " " after the filename.pdf and around Click... .pdf. was that
correct? I got the error message - "Can not open the specified file". While
in explorer tree, I highlighted the folder that contains the pdf files and
changed the setting in Tools to "open file in separate window". But that did
not help at all. Do you have any other suggestions?
Aurora



"Sheeloo" wrote:

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

In the formula
=HYPERLINK("C:\Documents and Settings\username\Desktop\Test.pdf","Click to
Open TEST.pdf")
replace C:\Documents and Settings\username\Desktop\Test.pdf with the
complete path and file name to your file

Click to Open TEST.pdf is just a message... you can have anything there...
quotes around both are important.

"Formula in Report" wrote:

Thank you for answering my call for Help - but I could not get your formula
to work.
I put in the " " after the filename.pdf and around Click... .pdf. was that
correct? I got the error message - "Can not open the specified file". While
in explorer tree, I highlighted the folder that contains the pdf files and
changed the setting in Tools to "open file in separate window". But that did
not help at all. Do you have any other suggestions?
Aurora



"Sheeloo" wrote:

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