Hello this is my first question to this forum. I have read many posts and have been helped by previous questions and answers.
I need to create a macro that reads a value in column A (equal to the opened filename) from an external file (excel, but I can convert it to something else if it would be better.).
and copy the value in column B to a textfield with a specific object id.
Here is our macro that takes the file name and places a copy of it in the bottom right corner of the illustration. It places it on the illustration layer in our template. If someone knows how to make the background behind the text fill white that would be awesome. Currently I change that after the number is placed.
Define h As Integer
Define w As Integer
w = activeDoc.window.pageX-2
h = 2
#Message "The height is " + h
#Message "The width is " + w
#Added below command to ensure number is placed on the Illustration number layer
ACTIVATE LAYER "Illustration Number"
Text Align Left
Text font 'Arial'
Text size 6
Create Text w h stripext(activeDoc.name)
Rotate selection w h 90
Thank you for the reply brifsen.
I already have the file name as text in my macro.
I need to use the file name and look for it in an external file and return the value in the column next to the file name as another text element in the illustration.
Does anybody have more help on this issue?
Best regards Andreas