Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative to SendKeys
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative to SendKeys
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SendKeys | Excel Programming | |||
How Can I Use SendKeys in MAC EXCEL? | Excel Programming | |||
Sendkeys | Excel Programming | |||
SendKeys | Excel Programming | |||
sendkeys | Excel Programming |