DDE an Alt-Enter (Newline) character
 

Hi

Does anyone know the ascii characters (or equivalent) for ALT-ENTER
(newline) when DDE'ing data to Excel?

Many thanks
Ross

DDE an Alt-Enter (Newline) character
 

Ross,

Try using ASCII 10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ross Field" wrote in message
...
Hi

Does anyone know the ascii characters (or equivalent) for
ALT-ENTER
(newline) when DDE'ing data to Excel?

Many thanks
Ross

DDE an Alt-Enter (Newline) character
 

I am not sure what u mean by DDE'ing as I am a newbie ..


I DID find out that ALT-ENTER translates to 0a Hex (i.e. Ascii 10)

Thanks
Abhinav

Ross Field wrote:

Hi

Does anyone know the ascii characters (or equivalent) for ALT-ENTER
(newline) when DDE'ing data to Excel?

Many thanks
Ross