View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default special characters from vba

Pedro,
Why not use the capability of Word and insert a table .
Or do you need to use ASCII characters for some reason ?

NickHK

"Pedro Leite" <naoehpreciso bl...
Good Morning

I have a bit of code that opens a new word doc, fill the document with
excel data, prints, close and so on
the thing is, the document is tabular and is limeted in row and columns
with " - " and " | "

example : ( make the window larger to fit )

now what i want is to use the box drawing characters available in the
extended ascii table ( corners, junction lines and so on ) asc 186 , 205
and some others.

the font used is courier new and has a sub set, called box drawing that
has these caracters. how can i use them ??

thank you

Pedro Leite from Portugal.





-------------------------------------------------------------------------------------------------------------------------

|Preto 800 |

|Nec- 775,0|Stk- 162,0|Enc- 613,0|Est- -55,0|Rec-
558,0|Csm- 720,0|Exc- 0,0|Sob- 0,0|

|Nec- 47,0|Stk- 64,0|Enc- -16,0|Est- 46,0|Rec-
30,0|Csm- 94,0|Exc- 49,0|Sob- 0,0|

|-----------------------------------------------------------------------------------------------------------------------|

| |

|-----------------------------------------------------------------------------------------------------------------------|

| |

|-----------------------------------------------------------------------------------------------------------------------|

| |

|-----------------------------------------------------------------------------------------------------------------------|

| |

|-----------------------------------------------------------------------------------------------------------------------|

| |

|-----------------------------------------------------------------------------------------------------------------------|

| |

-------------------------------------------------------------------------------------------------------------------------