Re: Open and view external file

[A17BPG]

Re: Open and view external file

Hi Everyone

Can anyone help with the following:

Is it at all possible to place a file location into a cell select this cell and open and view file then return to Excel.

ie say I wanted to access a PDF or Word file view contents then return to Excel and close the file used ?

Example
[TABLE="class: cms_table, width: 64"]
<tbody>[TR]
[TD]C:/Documents/School_Information_Sheet.pdf[/TD]
[/TR]
</tbody>[/TABLE]



Many thanks

A17BPG (Brian)

 

[MB110]

Re: Open and view external file

Insert > Links > Locate file using dialog box and click ok.

Click the link in the cell to view.

Close the file and Excel is still there.

 

[A17BPG]

Re: Open and view external file

Insert > Links > Locate file using dialog box and click ok.

Click the link in the cell to view.

Close the file and Excel is still there.

Hi MB110

Thanks for fast response, I sent question out via my iPad which unfortunately I do not have Excel on but tomorrow morning will try out on Laptop.

Again thanks for response if all works ok will let you know.

Regards A17bpg (Brian)

 

[MB110]

Re: Open and view external file

No problem. I've gotten plenty of help so it's nice to give back.

The Insert Hyperlink dialog will also allow you to give the link a custom name. Change the "Text to display:" field to whatever you like and it won't display a long and meaningless path. It could display "School Info" or "Click Here" or "Read Me"... or if you want your users to click it for sure give it an irresistible name (i.e."clickbait), something like "Click here to be Amazed!". You're only limited to text and your imagination.

Cheers,
MB110

 

[A17BPG]

Re: Open and view external file

Hi MB110

Excellent works perfect, thanks again for your input.

Regards. (A17BPG) Brian