Sending Excel cell data to specific points in Illustrator in VBA

[Boonorton]

I want to send the contents of A1 to an Illustrator document at 135, 172 and B1 to 135,190, same with A2/B2 will be at different coordinates as will A3/B3 and so on... I want to do this 6 times and save the document as a PDF. Then, it should clear and do it again. The columns will ALWAYS be A and B.

I would be most grateful for help on this seemingly simple task.

Thanks.

[CarlosCanto]

check this post on how to get you started with VBA

http://forums.adobe.com/thread/976607?tstart=0

[Boonorton]

Thanks, that is an EXCELLENT start. Are there any command for setting the X and Y coordinates directly?

[CarlosCanto]

yes, use

textFrame.Position = Array(x,y)

[Boonorton]

Thank you so much. I have been looking for a long time for how to send data to Illustrator from Excel.

Chris.

Date: Sun, 27 Oct 2013 22:15:33 -0700

From: forums_noreply@adobe.com

To: buckleycj@hotmail.com

Subject: Sending Excel cell data to specific points in Illustrator in VBA

Re: Sending Excel cell data to specific points in Illustrator in VBA

created by CarlosCanto in Illustrator Scripting - View the full discussion

yes, use

textFrame.Position = Array(x,y)

Please note that the Adobe Forums do not accept email attachments. If you want to embed a screen image in your message please visit the thread in the forum to embed the image at http://forums.adobe.com/message/5793060#5793060

Replies to this message go to everyone subscribed to this thread, not directly to the person who posted the message. To post a reply, either reply to this email or visit the message page:

To unsubscribe from this thread, please visit the message page at . In the Actions box on the right, click the Stop Email Notifications link.

Start a new discussion in Illustrator Scripting at Adobe Community

For more information about maintaining your forum email notifications please go to http://forums.adobe.com/message/2936746#2936746.

[Boonorton]

I entered the sample code you directed me to but I gat an error that said: ActiveX Component can't create object, and takes me to the line: Set iDoc = iApp.ActiveDocument. What have I done wrong?

Chris.

From: buckleycj@hotmail.com

To: jive-1412846405-1b6a6-2-3g5yc@mail.forums.adobe.com

Subject: RE: Sending Excel cell data to specific points in Illustrator in VBA

Date: Tue, 29 Oct 2013 15:33:09 -0600

Thank you so much. I have been looking for a long time for how to send data to Illustrator from Excel.

Chris.

Date: Sun, 27 Oct 2013 22:15:33 -0700

From: forums_noreply@adobe.com

To: buckleycj@hotmail.com

Subject: Sending Excel cell data to specific points in Illustrator in VBA

Re: Sending Excel cell data to specific points in Illustrator in VBA

created by CarlosCanto in Illustrator Scripting - View the full discussion

yes, use

textFrame.Position = Array(x,y)

Please note that the Adobe Forums do not accept email attachments. If you want to embed a screen image in your message please visit the thread in the forum to embed the image at http://forums.adobe.com/message/5793060#5793060

Replies to this message go to everyone subscribed to this thread, not directly to the person who posted the message. To post a reply, either reply to this email or visit the message page:

To unsubscribe from this thread, please visit the message page at . In the Actions box on the right, click the Stop Email Notifications link.

Start a new discussion in Illustrator Scripting at Adobe Community

For more information about maintaining your forum email notifications please go to http://forums.adobe.com/message/2936746#2936746.