Hello All,
I have cell with many characters(2000+) in it. I am finding it difficult to edit the same in excel. Wondering, if I could open the same in wordpad or winword?
Infact the below code, just opened the wordpad, without copying the current cell contents to wordpad :-( Note, I don't want to open it in notepad, since the contents of the cell are pasted from contents of word document and the formatting is not great when opened in notepad.
Request for an earlier resolution. Kindly, let me know, if there are any other alternatives?
Thanks
Sunil Kumar
Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+E
'
With Application
Selection.Copy
Shell "C:\Program Files\Windows NT\Accessories\wordpad.exe", 3
SendKeys "^v"
VBA.AppActivate .Caption
.CutCopyMode = True
End With
End Sub
Thanks
Sunil Kumar
Bookmarks