Re: (AS) from Excel To Indesign - newbie - Article 16278 - go-pugleaf

Article View: adobe.scripting.indesign

Article #16278

Back to adobe.scripting.indesign Previous Next

Re: (AS) from Excel To Indesign - newbie

#16278

From: Shane_Stanley
Date: Tue, 30 Sep 2003 22:17

22 lines
1309 bytes

This should get you started:

set n to 1
repeat
 tell application "Microsoft Excel"
  set x to Formula of Range ("A" & n)
 end tell
 if x = "" then
  exit repeat
 else
  tell application "InDesign 2.0.2"
   open myMaster
   set contents of parent story of text frame "Whatever" to x
   save document 1 to (pathToFolder & x)
   close document 1 saving no
  end tell
  set n to n + 1
 end if
end repeat

-- 
Shane Stanley,  sstanley@myriad-com.com.au

Technical Details

Message-ID: <BBA03E15.67E41%sstanley@myriad-com.com.au>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!webx

References: <2ccd95f2.-1@webx.la2eafNXanI>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,9f7e37f8a52776d9
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2003-09-30 15:37:55 PST
From: Shane_Stanley@adobeforums.com
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.scripting.indesign
Subject: Re: (AS) from Excel To Indesign - newbie
Message-ID: <BBA03E15.67E41%sstanley@myriad-com.com.au>
Date: Tue, 30 Sep 2003 15:17:26 -0700
References: <2ccd95f2.-1@webx.la2eafNXanI>
Lines: 23
User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.6
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Reply to Parent Message