Carriage Return using OLE2

[krindler]

Hello...

Does anyone have any sample code of putting a Carriage Return, in the Header of an Excel File, using OLE2? I have been playing around with this for a while and am having no luck.

Your help is much appreciated...

 

[sfvb]

I just insert an ascii character 13 which is the carriage return. Example:

OLE2.SET_PROPERTY(pagesetup, 'CenterHeader', '&"Tahoma,Bold" &14Line 1'||chr(13)||'Line 2'||chr(13)||'Line 3');