excel table to draft

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

I tried this out and just gotta say....NICE!!
impressive VBA and PDML skills.

tbmale
fyi

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.

Anyway, Awesome code, thanks allot!!!

Thanks

Feel free to change anything :)

One neat thing would be to align numbers to the right ... :D

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!

Try to play with the line

 wlen(i) = wlen(i) * TH / 8

modifying the width ratio (8) - a smaller figure means wider rows

ok thanks i will try

Hi,

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

Where exactly do you have difficulties?