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.
Bookmarks