Skip to main content
A
akjerrman1-Visitor
1-Visitor
June 28, 2021
Question

Import text to a defined text field in IsoDraw

  • June 28, 2021
  • 1 reply
  • 1470 views

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

 

1 reply

B
18-Opal
bfriesen18-Opal
18-Opal
June 28, 2021

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

    A
    akjerrman1-VisitorAuthor
    1-Visitor
    June 29, 2021

    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

    Terms & ConditionsCookie settingsAccessibility statement