SendKeys Method ignore parenthesis?

N

NooK

I have lots of text on a excel sheet which I am trying to send t
notepad and save in a text file, but the outcome text on notepa
doesn't have any parenthesis while the excel sheet has lot o
parenthesis, so SendKeys must be ignoring the parenthesis completelly
I think.

Is there anyway I can fix that?

Best Regards

Noo
 
J

Jim Rech

I think your better bet would be to save a text file directly from Excel.
Record a macro as you do it from the keyboard using File, save As to get the
right syntax. If the active sheet does not have the exact text you want,
add a new sheet, copy the text to it and save it.

--
Jim Rech
Excel MVP
|I have lots of text on a excel sheet which I am trying to send to
| notepad and save in a text file, but the outcome text on notepad
| doesn't have any parenthesis while the excel sheet has lot of
| parenthesis, so SendKeys must be ignoring the parenthesis completelly,
| I think.
|
| Is there anyway I can fix that?
|
| Best Regards
|
| NooK
|
|
| ---
|
|
 
Top