ScreenTip:=Chr(34) & ActiveSheet.Cells(lngRow, 1).Value & Chr(34)Ī.Address = Mid(A.ScreenTip, 2, Len(A. Hyperlinks.Add Anchor:=ActiveSheet.Cells(lngRow, 2), Address:=Chr(34) & _ĪctiveSheet.Cells(lngRow, 1).Value & Chr(34), TextToDisplay:="Open", _ 'Note that I don't add a hyperlink in Row 1. 'this program does not tolerate any blanks in the "A" column list. 'Because I'm using selection.End(xlDown).Select to find the complete list, 'a # mark which had originally occurred in the filename. '.and then correct the hyperlinks in case Excel misinterpreted Choose File>Place (or use the keyboard shortcut Ctrl/Cmd+D), then browse to select your Excel file. Click anywhere outside of any existing text or image frames to make sure nothing is currently selected. 'This subroutine will turn those cells into Excel hyperlinks. To import your Excel spreadsheet into an InDesign document, first open your InDesign document and choose the Selection Tool. 'Column "A" contains the text of links to some files. Sub Make_Column_A_into_hyperlinks_hashmarkworkaround() I was able to paste these hyperlinks successfully into Word and Outlook. Request that the person building the document.
How to link cells in excel to indesign full#
I made some Excel code that does this automatically for a sheet containing column A full of pound-sign-containing addresses (the text only), which fills column B with new working hyperlinks. Mark the option Create Links When Placing Text and Spread- sheet Files (See image to the right.) Cell styles. But if you create the hyperlink within Excel's object model, or modify the address of an existing hyperlink in Excel's object model, you can foist an un-magical # into Excel, or MS Word, or any other MS Office application that would normally have a problem. It looks like Excel interprets the '#' as a 'magic #' whenever Excel creates hyperlinks.
![how to link cells in excel to indesign how to link cells in excel to indesign](https://redokun.imgix.net/wp/assets/2016/10/20091140/import-an-excel-file-into-indesign-with-link_01-1024x658.png)
See this: īut this is bad if your hyperlink has a '#' sign in it without you intending to use this fancy Excel functionality. Whenever Excel sees a '#' sign in a hyperlink, it tries to interpret it as sort of a relative reference or a 'magic hash'. It does give fair warning that in the future the hash (#) might be problematic in a URL. In our corporate environment, we use IE as the default browser, and we have Compatibility View turned on by default, but somehow her settings had been changed. When she changed her document settings to IE7 Standards, closed the browser and then clicked the link from Excel, the page opened correctly in IE. The default setting in her browser was IE10 Standards. When I opened IE Developer Tools, I discovered that the default Document Standards setting in my browser was IE7 Standards. The key phrase is compatible MSIE 10.0 (mine reads compatible MSIE 7.0).
How to link cells in excel to indesign windows#
HTTP_USER_AGENT=Mozilla/5.0 (compatible MSIE 10.0 Windows NT 6.1 WOW64 Trident/6.0) HTTP_USER_AGENT=Mozilla/4.0 (compatible MSIE 7.0 Windows NT 6.1 WOW64 Trident/6.0 SLCC2. I investigated the http_user_agent value my version and found this:
![how to link cells in excel to indesign how to link cells in excel to indesign](http://kasyan.ho.ua/indesign/batch_process_scripts/list_links/list_links-1.png)
Others could open with IE, Chrome and Firefox. I had one user who could not open linked websites containing a # in the URL using IE.