Alternative to SendKeys

[Garry Rathbone]

Hi,
I'm writing some Access data into an Excel workbook. The
user wants some of the data to have a linebreak in a cell
(ALt-ENTER). I can simulate this using Sendkeys but
that's brutally slow and open to errors.

Any ideas how I can concatenate two pieces of text with
the equivalent of Alt-Enter between them? The code would
look something like:

objSheet.Cells(i, 5).Value = rst!Name & ????? & rst!
CashValue

Thanks for your help.

Garry

 

[papou]

Hello Garry
objSheet.Cells(i, 5).Value = rst!Name & vbLf & rst!CashValue

HTH
Regards
Pascal

 

[keepITcool]

use vbLF iso the ????? and excel will understand you..

vblf is a vba constant for chr$(10)..
using constants os more efficent that calling the chr$()
function all the time.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Garry Rathbone wrote :

 

[Garry Rathbone]

Thanks for the prompt replies guys! I can't believe it
was that simple. I was looking for something much more
complicated. D'OH!

Garry