Skip navigation
suemac80
Currently Being Moderated

How do I see a list of OLE links in my book?

Apr 9, 2013 4:41 PM

Tags: #links #ole

I have a FrameMaker 9.0 book that has several OLE links to Excel spreadsheets. How do I create a list of references to those spreadsheets, similar to the one I could create for a list of imported graphics?

 

I am aware of the Links dialog box, but due to the length of the path name and the restriction on resizing that dialog box (grrrr!), the information is unusable. 

 

Thanks in advance for your help!

 

Sue

 
Replies
  • Currently Being Moderated
    Apr 9, 2013 4:52 PM   in reply to suemac80

    You can't within FM. The Links dialog is the only mechanism within FM that lets you know about OLE links (that's one of the reasons OLE is not a best practices method for getting content into FM). Alternatively, FM will let you import Excel files by reference, so depending upon the content needed, this might be something else to consider.

     

    A last resort would be to create MIF verisons of your FM files and then use a grep-like search tool to find the OLE entries.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 10, 2013 12:42 PM   in reply to suemac80

    Sue,

     

    Unfortunately, the dialogue can't be re-sized and the behaviour is the same in version up to FM11.

     

    One thing that you might be able to try is to (at the system level) create a mapped drive to the deepest common level and use the drive in FM when linking, e.g. let K: map to "C:\... whatever ...\Model Reports\Asia\Korea data\Version 9.0\ "

     

    You might need to do a one-shot re-link or a search & replace in the MIF to do this to get the mapped drive to show.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points