Get output in notepad by VBA

[santoshloka]

i have some random Data in excel sheet which i want them in notepad

is it possible by VBA Code?

1=Text,2=Number,3=ID No..etc

 

[Kyle123]

Re: how to get output in notepad by VBA

In the absence of anything further to go on:

Sub test()

Open "C:\temp\test.txt" For Output As [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] 
    Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] , "1=Text,2=Number,3=ID No..etc"
Close [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] 

End Sub

 

[AdrianPH]

Re: how to get output in notepad by VBA

Sub outputToTxt()

Dim filePath as String
Dim textFile as Integer
Dim wholeFile As String

filePath = "C:\Users\Windows\Desktop & "\" & "NAMEYOUWANTTOSAVEFILEAS" & ".txt."" 'here you should enter the location where you want notepad to be saved on your computer
textFile = FreeFile

Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=TextFile][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Textfile]#Textfile[/URL] [/URL] , textYouWantToEnter 'overwrite textYouWantToEnter with the text you want to be output to notepad
Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=TextFile][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Textfile]#Textfile[/URL] [/URL] , textYouWantToEnter 'overwrite textYouWantToEnter with the text you want to be output to notepad
Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=TextFile][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Textfile]#Textfile[/URL] [/URL] , textYouWantToEnter 'overwrite textYouWantToEnter with the text you want to be output to notepad
Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=TextFile][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Textfile]#Textfile[/URL] [/URL] , textYouWantToEnter 'overwrite textYouWantToEnter with the text you want to be output to notepad
etc, etc.

Close [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=TextFile][URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Textfile]#Textfile[/URL] [/URL]

 

[santoshloka]

Re: how to get output in notepad by VBA

can i get attachemnt file @Kyle123?

whta is mean output as #1 clear info please..

 

[Kyle123]

Re: how to get output in notepad by VBA

What attachment file?

 

[santoshloka]

Re: how to get output in notepad by VBA

can yu make random excel sheet with code which can help to generate notepad document

take few cells and export them.
this is my intention

 

[Kyle123]

Re: how to get output in notepad by VBA

Just put that code in a module and run it. I'm not making you a workbook when you can do it much faster yourself