Results 1 to 3 of 3

Opening content of cell in winword or wordpad

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Opening content of cell in winword or wordpad

    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
    Last edited by 6StringJazzer; 11-17-2013 at 10:08 PM. Reason: Code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-11-2013, 06:58 AM
  2. Delete Content in a row while opening
    By Julian Schubert in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-28-2011, 07:26 AM
  3. Replies: 0
    Last Post: 06-24-2009, 09:33 PM
  4. Problem with open winword
    By lunar_star in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2008, 05:08 AM
  5. [SOLVED] Paste in WinWord, problems with several processes
    By lasse g in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1