Skip to main content
New Participant
October 28, 2013
Question

Sending Excel cell data to specific points in Illustrator in VBA

  • October 28, 2013
  • 1 reply
  • 992 views

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.

This topic has been closed for replies.

1 reply

CarlosCanto
Community Expert
October 28, 2013

check this post on how to get you started with VBA

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

BoonortonAuthor
New Participant
October 28, 2013

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

CarlosCanto
Community Expert
October 28, 2013

yes, use

textFrame.Position = Array(x,y)