In reference to Creating hyperlink from Excel FlowChart to MS Word Heading
I would like to know the correct syntax to hyperlink to a specific cell in an Excel Workbook from a Word document.
For example: Say I am in word document "Explaining" and I want to insert a hyperlink to the Excel file DataStuff, but to Cell ZX200. How would I do this manually, without VBA/MACROS?
I already know that to hyperlink to DataStuff I would type
Then hit ENTER. (It then becomes an underlined hyperlink. Clicking on it opens DataStuff)
However, I want to add the fact that it should goto cell ZX200, not just open DataStuff at cell A1. The following does NOT work. Can someone fix the syntax for me?
Does not work: File:///[c:\users\Win7User\desktop\DataStuff.xlsx]Sheet1!ZX200
I don't get how the Excel to Word question was answered in about 10 minutes, and my Word to Excel question accumulated crickets and tumbleweed. No MS Word experts??
I've figured it out after browsing many useless, and one useful document. The correct syntax is:
That should be typed into your word document, and will go to cell ZX200 in worksheet Sheet1 in Excel. Using the information fro the hyperlink I had in my question, you now have a wonderful BIJECTION between Word and Excel hyperlinking. So that when you send people somewhere, you can also send them back!