Back

If your email is not recognized and you believe it should be, please contact us.

Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • in reply to: Linked tables to Excel spreadsheets #96941
    San Marco
    Member

    Waow that’s a real magic trick!!

    Thank you so much !!!

    in reply to: Linked tables to Excel spreadsheets #96938
    San Marco
    Member

    It makes sense, although I was hoping that the script would have been able to avoid some restrictions and go directly to some functionalities. But it seems that this is not the case. Too bad!

    in reply to: Linked tables to Excel spreadsheets #96937
    San Marco
    Member

    Hi Kai,

    Thank you very much for your proposal, but to avoid further problems I spent my weekend creating the different tables temples and now, it is up to my dear colleagues to copy/past the data into these tables. But anyway I’m still curious to understand what prevents these embedded files from being unlinked.

    in reply to: Linked tables to Excel spreadsheets #96935
    San Marco
    Member

    Amazing !!!

    Finally I succeeded to write the hereunder Javascript, which works fine, but with the same result ! It’s impossible to unlink the Excel files without, first, updating the links. But on the other hand, I’m allowed to remove them, which doesn’t really help me… Grrrr

    Maybe someone can tell me what I’m missing here ???

    if (app.documents.length == 0) alert(“No documents are open. Please open a document and try again.”);
    var myLink;
    var linkName;
    var myDoc = app.activeDocument;
    var links = myDoc.links;
    var MyCounter= 0;
    for(var i = 0; i<links.length; i++){
    myLink = links[i];
    linkName = myLink.name;
    if (myLink.status == LinkStatus.LINK_OUT_OF_DATE || myLink.name.substr(linkName.length-5) == ‘.xlsx’){
    MyCounter++;
    alert (“link nb “+MyCounter+”: “+myLink.name);
    //myLink.update();
    //myLink.remove();
    //myLink.unlink();

    }
    }

    in reply to: Linked tables to Excel spreadsheets #96933
    San Marco
    Member

    Hi Bob,

    I know this old post which confirms what I was afraid of, it is impossible to solve the problem through the interface. That’s why I’m looking for a script (or the appropriate functions) to un un unlink embedded files.

    Thank you!

    in reply to: Linked tables to Excel spreadsheets #96892
    San Marco
    Member

    Hi Bob,

    Thanks for your suggestion but unfortunately it doesn’t change anything, it’s still impossible to unlink the files, I’m only allowed to relink the file or update the links which I want to avoid absolutely.

    Thank you again!

    in reply to: Linked tables to Excel spreadsheets #96681
    San Marco
    Member

    This is a recurrent problem that I have not yet been able to fix (those tables have been shared, duplicated and modified many times in various catalogues). I hope some kind soul help me to get rid of it! Thank you!!

Viewing 7 posts - 1 through 7 (of 7 total)