Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
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.
help/Andreas
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.
Thanks
Bryon
Macro Add_FileName
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"
Select none
Text Align Left
Text font 'Arial'
Text size 6
Create Text w h stripext(activeDoc.name)
Rotate selection w h 90
End Macro
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