VBA to Convert Excel File to Text File - Transfer Excel data to Notepad Automatically

You can automate transfer of data from Excel to Notepad with simple VBA Programming. This Excel VBA example explains how to export excel data into text file step by step.

[rickyrubin]

Thanks for sharing this info! didn't need the loop function. And you had enough detail here to adjust/modify what I needed. 😁

[JuanPabloVivasR]

Hi thank you very much!, but I wonder how I could apply this macro to a range of sellected cells. Thanks.

[nitingupta]

Hello,
Thanks for sharing this very useful video !
Could you advise how this logic can be extended if a particular column from multiple tabs needs to be extracted to a text file ?

[RANJEETSINGH-ybkw]

as per my understanding #1 is used to create notepad file, so can i get some reference about what all other file can be created by changing the number followed by #

[satishchaurasiaya]

Thanks alot . I salute you. The way you are teaching is perfect 👌

[gopalkrishnan]

Hi sir..I want to automate the data from excel to text...in that excel so many data is there..in that I required only 2 column copy that data n paste in notepad

[rimantasdanilevicius]

Thanks for this tutorial, but how just to copy paste all sheet content and do not modify data at all? I want to copy data as it is from sheet and paste to txt file.

[vishnuram]

Thanks, How to pass range dynamically. eg today we have 12 records tomorrow may be we have like 120 records without edit vba code how we can pass it

[laxmanpoudel]

perfect i was searching same . it was difficult for me to transfer data in comma format . thank u

[pavansapate]

Hi thank you, before generating text file, how to append a particular column data with adding additional data??

[lotfibenmansour]

very helpful, many thanx, but i have a request as following : if within this we need also that a specific column to become ("0.000"), who to include it, i already tried, but did not get the result of the row as 3 decimals .please comment dear .

[ahmeterdemylmaz]

Firstly I appreciate you for sharing your own information so useful and awesome teaching I'm glad to be here and your videos ; but my operating system didn't work that is my codes werent work successfully . I didn't even realize my fault, my computer sent a Run- time error '75', Path/File access error after click on the command button . Please help me How can I obtain correct result this type of trouble ( 5 th code didn't work I haven't solve this problem yet . This code start Open filename For Output As #1 )

[jonnathanjon]

Hello. Instead of a pre defined range, Can you help to transfer only the selected ranged with a prompt for a file name while saving to the text file?. I wanted to save the code as add in so that can be applied to any workbook I open. Any thoughts? ty

[safiuddinsamsir]

Thank you so much for your sharing knowledge

[sankarnagboggula]

How it will works if my text have CHINESE or some other language. Hope we need to use UTF-8! May I know how to use it?

[santoshkamala]

Thank you. Do you have anything which can convert EXCEL to XML ?

[jaycrook]

Hello. I like the videos. How do I open the text file after it's created from vba? Thank you, Jay.

[rajeshshah]

Sir, Is it possible to copy a range from excel to notepad++..??

[bangkokbluescricketclub]

Very Nice code, can Define Text file name and folder name in excel file, i want to .txt file to saved as defined name in the cell and the path

[vigneshravi]

Wow usefull video.... Bro I want to remove trailing space in text file using VBA... How to do Trim function not removing trailing space.... Tell bro