ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendKeys Method ignore parenthesis? (https://www.excelbanter.com/excel-programming/306087-sendkeys-method-ignore-parenthesis.html)

NooK[_51_]

SendKeys Method ignore parenthesis?
 
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

--
Message posted from http://www.ExcelForum.com


Jim Rech

SendKeys Method ignore parenthesis?
 
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
"NooK " wrote in message
...
|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
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|



NooK[_55_]

SendKeys Method ignore parenthesis?
 
I tried that already but in my case it doesnät work that is why I had t
go for other solution.

http://www.excelforum.com/showthread...hreadid=244630

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com