ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Link (https://www.excelbanter.com/excel-discussion-misc-queries/135081-excel-link.html)

Erika

Excel Link
 
I have a link inside an excel spreadsheet. When I convert this spreadsheet
to html, I want to be able to click on the link inside the spreadsheet and
have the new spreadsheet open in a new window?

How do I set that up?

Anne Troy

Excel Link
 
Hi, Erica. The following should work. Assume that your link, in html view (or
just use a text editor after you save as html), and your link looks like this
in html:

<a href="Storage\groc.xls"<span style='color:blue'C:\Docum<span
style='display:none'ents and
Settings\Administrator\Desktop\Storage\groc.xls</span</span</a

Change it to say this:


<a target="_blank" href="Storage/groc.xls"C:\Docum<span
style='display:none'ents and
Settings\Administrator\Desktop\Storage\groc.xls</span</a

--
~Anne Troy
www.OfficeArticles.com


"Erika" wrote:

I have a link inside an excel spreadsheet. When I convert this spreadsheet
to html, I want to be able to click on the link inside the spreadsheet and
have the new spreadsheet open in a new window?

How do I set that up?



All times are GMT +1. The time now is 02:24 AM.

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