cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Import text to a defined text field in IsoDraw

akjerrman
4-Participant

Import text to a defined text field in IsoDraw

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

 

2 REPLIES 2
bfriesen
14-Alexandrite
(To:akjerrman)

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

akjerrman
4-Participant
(To:bfriesen)

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

Announcements