View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default I can't open PDF files when using the hyperlink

I have to explain how a link is really opened. didn't want to go into the
details unless this was the problem.

Again go to the start button and select run
enter cmd.exe
This will bring up a command window. type assoc .pdf

On my computer it returns .pdf=AcroExch.Document. It should return
something similar for you. the association is set in the windows exploreer
and should of automatically got updated when Adobe 7.0 get installed

Open up a window explorer.the easy way is double click on My Computer on the
desk top.

Select Tools - Folder Options - Files types
Look for .pdf in the window.
my computer shows Adobe Acrobat 7.0 document

click on .pdf and then press advance
Press Open and then Edit

The application used to perform action has
"C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe" "%1"

The %1 is the first parameter which is the file name.

I also have Use DDE checked

Application AcroRd32

And Topic System

I would make sure the executable (AcroRd32.exe) is in the path (folder)
shown and that you have permission to execute the file AcroRd32.exe.




"zwalbij" wrote:

Hi Joel,

Thanks for your reply. I really appreciate it as it brought me one step
further. I know now that the problem should be the Windows setup and not
Excel. Apparently there's something wrong in the setup of Windows, because of
which it still doesn't open. By the earlier. I use Adobe 7.0. When using an
earlier version, I didn't encounter any problem. Could this have something to
do with it?

Thanks for your patience and your reply.

Cheerz,
Alex


"Joel" wrote:

I just successfully opened a linked PDF file.

Put a pdf file in the C:/temp directory
Try on your start menu in the run box type in the following

acrord32 - this should open adobe with no
document
acrord32 c:/temp/abc.pdf - this should openadobe with document abc


If these fail, then the problem is not with excel. There is something wrong
with Window setup. I trying to isolate the problem to make sure it is an
excel problem.

I right clicked on the cell where I wanted the link and selected hyperlink.
then I made sure that Existing file or Webpage was selected.

"zwalbij" wrote:

Hi everyone,

I encounter the following problem. All my hyperlinks work except for the
hyperlinks that refer to PDF files. When I click on the hyperlink the
computer wants to start up the application Adobe Acrobat Reader, but within a
fraction of a second the application closes again. I think a setting is
wrong, because of which Excel doesn't allow me to open up a linked pdf.file

How can help me out? Thanks in advance.

A. Bijl,
The Netherlands