I've made a little macro for transferring the selected area from an excel sheet as a table in draft and I would like to share it with the community.
I use it mainly for BOMs.
It generates a
I did change two lines of code to make this work better for my needs. the first change was just a preference but I diffently would keep the second change.
1st change, the line... fp.writeline ("NEW NOTE /" + fname)[/i]
was changed to... fp.writeline ("NEW NOTE")[/i]
just would rather name the note myself then have some long filename for the name.
then I changed...
buf = buf & "Origin Offset X " & x & " Y " & y & clrf[/i]
to buf = buf & "Origin Offset X " & x & ".5" & " Y " & y & clrf[/i]
this was so the text was slightly offseted the STRA and not right on the line. Makes it look neater.
my problem is, that the macro destroy the variabel of the CHEIG....for the note the cheig is correct (in this case 4mm) but for the texp the cheig is replaced to cheig 0...what is the Problem?
ah sorry i think i solved the problem...i defined the GLOBAL TH to PUBLIC TH...because with GLOBAL TH i had a failure and cannot run the macro...Thanks, NICE WORK!
I just saw this thread and looks it will be very helpful. I'm not a programmer or have enough knowledge in PML. Could you give it a little more explanation on how to used this? thanks.
[QUOTE=tbmale;68754]Hi all,
I've made a little macro for transferring the selected area from an excel sheet as a table in draft and I would like to share it with the community.
I use it mainly for BOMs.
It generates a