This content has been marked as final. Show 3 replies
On 4/6/08 7:21 PM, "mark hofhuis" <firstname.lastname@example.org> wrote:<br /><br />> can I name a specific field from an .xls and place it in a specific textbox in<br />> InDesign.<br /><br />You can use a reference to a particular cell or cells, or you can use some<br />kind of test to find it -- putting it into an InDesign document is then<br />easy. <br /><br />> And pick a specific line in a .doc file and place it also in a<br />> specific text-box?<br /><br />Sure.<br /><br /><br />-- <br />Shane Stanley <email@example.com>
Is there anyone that can help me on my way.. point me to a site, or has a similar script that I can modify?
Word and Excel both come with AppleScript Reference guides as PDFs, or the guides can be downloaded from MS support site if you don't have the install CDs. The guides have coding snippets that can show you the basics of talking to various parts of your source spreadsheet or documents, and there are sample scripts and forums all over.
InDesign also has a scripting guide and example scripts as well. There are plenty of examples in this forum of ways to put captured data into particular places/elements/objects in an ID document, and how to label those places so that they can be recognized by scripts.
The complexity of your script will depend on how you will recognize the data you need to move from doc and xls. For example, I have a simple script that reads a Word document that is a list of e-mail addresses and then finds each address in an Excel spreadsheet and turns on a highlight color in the matching cell. Sounds like you will be reading a Word file, then finding a job number to use as a pointer to several cells in Excel and migrating all the captured data to text blocks in InDesign. That's a bit more involved filtering and selection task than mine, so will require some patience and time to script.