Thread: Paste into opened notepad file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oOpsy[_7_] oOpsy[_7_] is offline
external usenet poster
  
Posts: 1
Default Paste into opened notepad file

May i know how do i continue from my code below in order to allow me to
copy sheet3 cells A1:A42 into the opened file? I am able to call
notepad to open the .xml file but i need to paste the data from excel
into this opened file.Thanks!!

Private Sub CommandButton1_Click()
Shell "C:\Windows\Notepad.exe 'C:\project\fyp1.xml"

End Sub


--
oOpsy
------------------------------------------------------------------------
oOpsy's Profile: http://www.excelforum.com/member.php...o&userid=29132
View this thread: http://www.excelforum.com/showthread...hreadid=489798

Reply With QuoteReply With Quote