I'm using the following code to copy columns of data in a worksheet of mine. The code once activated will open "notepad" and copy the columns of data in my excel worksheet. Here is the code:
Sub notepad()
'The range that contains the values
Range("A3:H2000").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
Could anyone help me (if it is possible) to edit this code so that after the data is copied in notepad that the notepad document will be saved automatically as "Analysis.txt" and then placed on the C drive closing notepad and leaving my excel spreasheet still visible? Any suggestions and or assistance would be greatly appreciated. I'm trying to simplify some time consuming elements with this code. Thanks in advance!
Bookmarks