import excel data into text fields

[jscottimd]

i'm new to scripting in illustrator and was wondering if anyone could point me to resuources that will help me  create a script that pulls data from an excel or xml document into a variable text field in illustrator and then save the document as an eps or ai file. i've searched the forums and googled but haven't been able to find anything solid. thanks in advance.

[Muppet_Mark-QAl63s]

If you are familiar with xml then you should see if variable data is going to service your needs first… It may be possible to have excel format the data required in to a format that Illustartor's variable data and data sets works with… Otherwise the scripted route would be to save your Excel data to an intermediate file such as CSV or TDT then have script read the data in… Snippets of code for this are posted here in the forum…

[jscottimd]

thanks. i've searched and am searching this forum for the snippet with no luck. i've even narrowed it down in the search options. i will keep searching if anyone has any links it would be appreciated. thanks in advance

[CarlosCanto]

are you on Windows? Visual Basic can talk to Illustrator straight from Excel

here's a translation sample

http://forums.adobe.com/thread/773143