Hyperlinking from Excel to Word bookmarks

[MWE]

I have had a consistent problem hyperlinking from Excel to bookmarks in Word documents. I can navigate to the document and then manually add the link text required for a particular bookmark. But if I click on the BookMarks button after selecting the target Word file, I get an error


Microsoft Excel could not open this file or could not parse a file of this type


The problem is consistent across three op/sys (Win2K, WinXP/SP1 and WinXP/SP2) all running essentially the same version of Excel2000.

Any thoughts?

[Killian]

Yeah, the XL dialog for bookmarks only seems to allow references within the workbook ("bookmark" being, therefore, a complete misnomer)
You can do it by using the HYPERLINK formula synax:


=HYPERLINK("[C:\Documents and Settings\Killian\Desktop\Test.doc]bmkTest", "A freindly link name")

where "bmkTest" is the name of your Word doc's bookmark

[MWE]

Yeah, the XL dialog for bookmarks only seems to allow references within the workbook ("bookmark" being, therefore, a complete misnomer)
You can do it by using the HYPERLINK formula synax:


=HYPERLINK("[C:\Documents and Settings\Killian\Desktop\Test.doc]bmkTest", "A freindly link name")

where "bmkTest" is the name of your Word doc's bookmark
thanks for the reply.

I know several "workarounds", I was hoping that the implied functionality actually worked (and I was doing something wrong:banghead:)

[Killian]

I was hoping that the implied functionality actually workedIndeed, clicking a "Bookmarks" button and expecting MSExcel to parse an MSWord document and list it's bookmarks doesn't seem like too wild an assumption, does it? :whistle:
but then, it's this kind of "MSOffice Integration" that keeps VBA coders in business :)

[MWE]

Indeed, clicking a "Bookmarks" button and expecting MSExcel to parse an MSWord document and list it's bookmarks doesn't seem like too wild an assumption, does it? :whistle:
but then, it's this kind of "MSOffice Integration" that keeps VBA coders in business :)

smells like a good KB