Results 1 to 14 of 14

Save Notepad through VBA Macro, having Copied Range of Cells, Pasted into notepad

Threaded View

analystbank Save Notepad through VBA... 12-18-2014, 01:37 AM
:) Sixthsense :) Re: Save Notepad through VBA... 12-18-2014, 01:45 AM
analystbank Re: Save Notepad through VBA... 12-18-2014, 04:51 AM
:) Sixthsense :) Re: Save Notepad through VBA... 12-18-2014, 04:59 AM
analystbank Re: Save Notepad through VBA... 12-18-2014, 05:10 AM
:) Sixthsense :) Re: Save Notepad through VBA... 12-18-2014, 05:29 AM
analystbank Re: Save Notepad through VBA... 12-18-2014, 05:35 AM
:) Sixthsense :) Re: Save Notepad through VBA... 12-18-2014, 05:56 AM
analystbank Re: Save Notepad through VBA... 12-18-2014, 08:51 AM
:) Sixthsense :) Re: Save Notepad through VBA... 12-18-2014, 09:26 AM
analystbank Re: Save Notepad through VBA... 12-19-2014, 01:19 AM
YasserKhalil Re: Save Notepad through VBA... 12-19-2014, 04:09 AM
analystbank Re: Save Notepad through VBA... 12-19-2014, 04:49 AM
analystbank Re: Save Notepad through VBA... 12-22-2014, 02:14 AM
  1. #1
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2021
    Posts
    273

    Save Notepad through VBA Macro, having Copied Range of Cells, Pasted into notepad

    My current macro, copies range of rows from a sheet, and puts it into Notepad.

    Sub NoteTxt ()
        Sheets("Sheet1").Select
        Range("S1:S200").Copy
        'Start Notepad And let it recieve focus
        Shell "notepad.exe", vbNormalFocus
        'Send the keys CTRL+V To Notepad (i.e the window that has focus)
        SendKeys "^V"
    End Sub

    I seek help to save the notepad file to a specific location on Drive, say C:\ABC\Note1.txt

    Each time, the notepad file would be overwritten.

    Thanks in Advance.
    Last edited by analystbank; 12-18-2014 at 01:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Opening Notepad a saved notepad file and copying the data on it
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2014, 06:18 PM
  2. Replies: 1
    Last Post: 01-14-2014, 04:18 PM
  3. Remove marching ants after notepad macro opens notepad
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-07-2014, 09:47 PM
  4. how to copy selected notepad text and paste it in other notepad with macro
    By Guru232 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 04-24-2013, 04:43 AM
  5. [SOLVED] Macro to export range of cells to notepad file.
    By MrIdontknowexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2012, 03:17 PM

Tags for this Thread

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