Skip to main content
rombanks
rombanks
Inspiring
November 3, 2019
Question

Changing path of linked Excel files

  • November 3, 2019
  • 1 reply
  • 621 views

Hello fellows,

 

Is it possible to programmatically change the path of an Excel sheet linked into a Framemaker file? AFAIK, the path of text insets can be modified using ES, but I couldn't find info on how to do that on OLE objects like Excel. How Adobe could omit this capability? My Excel files sit on a network drive. The problem is that while the path was accessible on Win7 using a WINS query, on Win10 the path cannot be accessed as the OS uses DNS and not WINS. So I need to change the path of dozens of Excel files to allow opening of FM files. 

 

TIA,

Roman

This topic has been closed for replies.

1 reply

frameexpert
Community Expert
frameexpertCommunity Expert
Community Expert
November 3, 2019

It has been awhile since I checked, but previously I found that the path to OLE objects was not exposed to FrameMaker scripting, either in FrameScript or ExtendScript. I have not checked the FDK.

www.frameexpert.com
    rombanks
    rombanksAuthor
    Inspiring
    November 3, 2019

    Hi Rick,

     

    I appreciate your response!

    Isn't it weird that Framemaker allows adding links to OLE objects but doesn't support batch path updates?

    I'll try to check with the support if they can look into this issue. This is an unjustifiied limitation, especially these days, when everything is stored on the cloud. 🙂

     

    Best Regards,

    Roman

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices