Re: Excel Link References (VB)

Article View: adobe.scripting.indesign

Article #17604

Back to adobe.scripting.indesign Previous Next

#17604

From: Olav Kvern
Date: Sat, 24 May 2003 18:16

11 lines
1396 bytes

Stu--

I just checked up on this--the range information is not available to scripting. (I also found that it's not available to the UI, either, when the spreadsheet is inserted in existing text--no link is created. When you place an Excel file as a separate text frame, you get the link info.)

There was an outside chance that it would be reflected in the ExcelImportPreferences after a relink or place operation, but no such luck.

One possible workaround--when you set the ExcelImportPreferences to a specific range/sheet/file before placing the Excel file, store that that information in the Label of the TextFrame containing the imported Excel data.

Thanks,

Ole

Technical Details

Message-ID: <1de92bde.4@WebX.la2eafNXanI>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX

References: <1de92bde.-1@WebX.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,f0002da46e73f93b
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2003-05-24 11:38:19 PST
From: "Olav Kvern" <okvern@adobe.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.scripting.indesign
Subject: Re: Excel Link References (VB)
Message-ID: <1de92bde.4@WebX.la2eafNXanI>
Date: Sat, 24 May 2003 11:16:25 -0700
References: <1de92bde.-1@WebX.la2eafNXanI>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message