title: How to open and save a notepad.exe using Macro
body: <p>I'm new to programming and so I have come here for some help.</p>
  
  <p>I need to copy a text field from excel and paste it in a notepad and then save the notepad with the specific name to a specific location. These things should be done with the help of Macro.</p>
  
  <p>Any help would be highly appreciated</p>
  
  <p>I was able to copy the text from excel and paste in Notepad, not sure how to save it in a new location</p>
  
  <pre><code>sub Macro2()
  
      Range("A5").Select
      Selection.Copy
      Shell "notepad.exe", vbMaximizedFocus
      SendKeys "^V"
  
  End Sub
  </code></pre>