ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink to a file (https://www.excelbanter.com/excel-discussion-misc-queries/19066-hyperlink-file.html)

Princess Leia

Hyperlink to a file
 
Working in Excel2003, I'm trying to hyperlink to a .pdf, but the Acrobat
window won't stay open. The knowledgebase says that it'll only keep a
hyperlinked file open when it's "dirty" - when it's been modified since the
last save (i.e., it's open on your desktop already because you're working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database over into
Access in the hopes that it plays better with file linking.

Dave Peterson

IIRC, the problem was with xl97 and the workbook wouldn't stay open after the
hyperlink was started (unless that workbook was dirty).

But this doesn't address the situation when the .pdf (acrobat window) closes.

Are you sure it's closing.

There have been times when I'm closing windows and I see an Adobe window waiting
for me to respond to one of those "do you want me to check for updates".

And since that window was hidden (for me), I didn't answer and the .pdf file was
never opened.

(just a guess.)

Princess Leia wrote:

Working in Excel2003, I'm trying to hyperlink to a .pdf, but the Acrobat
window won't stay open. The knowledgebase says that it'll only keep a
hyperlinked file open when it's "dirty" - when it's been modified since the
last save (i.e., it's open on your desktop already because you're working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database over into
Access in the hopes that it plays better with file linking.


--

Dave Peterson

Gary Brown

I had the same problem so I went to google.
Evidently, you can open a pdf with adobe reader just fine, but using the
full version bombs out. It's a bug. A new update is supposed to resolve
this (knock on wood). I'm going to try it tonight. The update site is...

Adobe 7.0.1 update download site...
http://www.adobe.com/support/downloa...13&fileID=2551

HTH,
Gary Brown

"Dave Peterson" wrote:

IIRC, the problem was with xl97 and the workbook wouldn't stay open after the
hyperlink was started (unless that workbook was dirty).

But this doesn't address the situation when the .pdf (acrobat window) closes.

Are you sure it's closing.

There have been times when I'm closing windows and I see an Adobe window waiting
for me to respond to one of those "do you want me to check for updates".

And since that window was hidden (for me), I didn't answer and the .pdf file was
never opened.

(just a guess.)

Princess Leia wrote:

Working in Excel2003, I'm trying to hyperlink to a .pdf, but the Acrobat
window won't stay open. The knowledgebase says that it'll only keep a
hyperlinked file open when it's "dirty" - when it's been modified since the
last save (i.e., it's open on your desktop already because you're working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database over into
Access in the hopes that it plays better with file linking.


--

Dave Peterson


Dave Peterson

Thanks for the post--now google has it again!

(I've only used the free reader.)

Gary Brown wrote:

I had the same problem so I went to google.
Evidently, you can open a pdf with adobe reader just fine, but using the
full version bombs out. It's a bug. A new update is supposed to resolve
this (knock on wood). I'm going to try it tonight. The update site is...

Adobe 7.0.1 update download site...
http://www.adobe.com/support/downloa...13&fileID=2551

HTH,
Gary Brown

"Dave Peterson" wrote:

IIRC, the problem was with xl97 and the workbook wouldn't stay open after the
hyperlink was started (unless that workbook was dirty).

But this doesn't address the situation when the .pdf (acrobat window) closes.

Are you sure it's closing.

There have been times when I'm closing windows and I see an Adobe window waiting
for me to respond to one of those "do you want me to check for updates".

And since that window was hidden (for me), I didn't answer and the .pdf file was
never opened.

(just a guess.)

Princess Leia wrote:

Working in Excel2003, I'm trying to hyperlink to a .pdf, but the Acrobat
window won't stay open. The knowledgebase says that it'll only keep a
hyperlinked file open when it's "dirty" - when it's been modified since the
last save (i.e., it's open on your desktop already because you're working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database over into
Access in the hopes that it plays better with file linking.


--

Dave Peterson


--

Dave Peterson

Gary Brown

The full link to the google answer I found is (watch the wrapping)...

http://groups-beta.google.com/group/...6441e89a8f5985

HTH,
Gary Brown


"Gary Brown" wrote:

I had the same problem so I went to google.
Evidently, you can open a pdf with adobe reader just fine, but using the
full version bombs out. It's a bug. A new update is supposed to resolve
this (knock on wood). I'm going to try it tonight. The update site is...

Adobe 7.0.1 update download site...
http://www.adobe.com/support/downloa...13&fileID=2551

HTH,
Gary Brown

"Dave Peterson" wrote:

IIRC, the problem was with xl97 and the workbook wouldn't stay open after the
hyperlink was started (unless that workbook was dirty).

But this doesn't address the situation when the .pdf (acrobat window) closes.

Are you sure it's closing.

There have been times when I'm closing windows and I see an Adobe window waiting
for me to respond to one of those "do you want me to check for updates".

And since that window was hidden (for me), I didn't answer and the .pdf file was
never opened.

(just a guess.)

Princess Leia wrote:

Working in Excel2003, I'm trying to hyperlink to a .pdf, but the Acrobat
window won't stay open. The knowledgebase says that it'll only keep a
hyperlinked file open when it's "dirty" - when it's been modified since the
last save (i.e., it's open on your desktop already because you're working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database over into
Access in the hopes that it plays better with file linking.


--

Dave Peterson


Gary Brown

I downlaoded the update. It works :O
I can now open pdfs from Excel.
Gary Brown


"Gary Brown" wrote in message
...
The full link to the google answer I found is (watch the wrapping)...

http://groups-beta.google.com/group/...6441e89a8f5985

HTH,
Gary Brown


"Gary Brown" wrote:

I had the same problem so I went to google.
Evidently, you can open a pdf with adobe reader just fine, but using the
full version bombs out. It's a bug. A new update is supposed to resolve
this (knock on wood). I'm going to try it tonight. The update site
is...

Adobe 7.0.1 update download site...
http://www.adobe.com/support/downloa...13&fileID=2551

HTH,
Gary Brown

"Dave Peterson" wrote:

IIRC, the problem was with xl97 and the workbook wouldn't stay open
after the
hyperlink was started (unless that workbook was dirty).

But this doesn't address the situation when the .pdf (acrobat window)
closes.

Are you sure it's closing.

There have been times when I'm closing windows and I see an Adobe
window waiting
for me to respond to one of those "do you want me to check for
updates".

And since that window was hidden (for me), I didn't answer and the .pdf
file was
never opened.

(just a guess.)

Princess Leia wrote:

Working in Excel2003, I'm trying to hyperlink to a .pdf, but the
Acrobat
window won't stay open. The knowledgebase says that it'll only keep
a
hyperlinked file open when it's "dirty" - when it's been modified
since the
last save (i.e., it's open on your desktop already because you're
working on
it). That seems pretty dumb to me, so obviously (I hope) I'm missing
something. Any ideas?

The other alternative that I see is for me to change this database
over into
Access in the hopes that it plays better with file linking.

--

Dave Peterson





All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com