Re: $$Excel-Macros$$ copy data from excel to Notepad using VBA code

2012-03-21 Thread NOORAIN ANSARI
Thanks Mangesh, Please follow this excel macro group on regular basis and Start recording macros, and perform actions in the excel spreadsheet.The macro recorder will record macro. A lot of the lines may be superfluous, but you'll get a general perspective of how macro works. Slowly, you'll learn

Re: $$Excel-Macros$$ copy data from excel to Notepad using VBA code

2012-03-21 Thread NOORAIN ANSARI
Dear Naresh, pls try it.. Sub copyPastedata_in_Notepad() With Application Selection.Copy Shell "notepad.exe", 3 SendKeys "^v" VBA.AppActivate .Caption .CutCopyMode = False End With End Sub On Wed, Mar 21, 2012 at 8:16 PM, Naresh V wrote: > Team, > >I have data in excel sheet column E,