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

[@rickyrubin5889]

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

[@Angel_Heart2009]

More and clear explanation needed

[@satishchaurasia84ya]

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

[@ExcelDestination]

Thanks and welcome

[@laxmanpoudel5562]

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

[@ExcelDestination]

You are welcome

[@JuanPabloVivasR]

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

[@rimantasdanilevicius6754]

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.

[@gopalkrishnan9944]

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

[@RANJEETSINGH-yb2kw]

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 #

[@safiuddinsamsir8349]

Thank you so much for your sharing knowledge

[@ExcelDestination]

Welcome

[@nitingupta84]

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 ?

[@vishnuram3860]

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

[@jonnathanjon1]

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

[@ExcelDestination]

there would be little different code. For ne excel vba support, you can write to [e-mail]

[@pavansapate3649]

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

[@MrDushyant123]

How we can create multiple txt file from multiple excel sheet..

[@amrinder9585]

It's working ,thank you 👍

[@ExcelDestination]

Welcome 👍

[@DivineArtemis]

Very helpful. I will give it a try later

[@ExcelDestination]

Great!

[@SankarNag_B]

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?

[@ahmeterdemylmaz2786]

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 )

[@ExcelDestination]

not sure about run time erro 75. let me research on this.

[@ahmeterdemylmaz2786]

@@ExcelDestination thank you so much ı am waiting your answer

[@johnewers4389]

This helped a lot! Thanks

[@ExcelDestination]

Glad it helped!

[@devinbernsie1319]

how can i add page breaks between each row?

[@lotfibenmansour937]

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 .

[@frankholland5301]

Brilliant. Many thanks for sharing this.

[@ExcelDestination]

Glad you enjoyed it

[@rajeshshah6758]

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

[@ExcelDestination]

Yes Sir, It is possible. you can check the tutorial for that at following link : kzbin.info/www/bejne/r52aeH6Gja5sqtE

[@rajeshshah6758]

@@ExcelDestination Sir, I have my connected workings in Notepad++ . I don't have any knowledge of VBA codes. Everything I have done is through formulas. I copy the data from excel and paste it to notepad + +. After that I take the path of the XML path and paste in to tally.If you help me create a macro in excel, in which it will select the data in excel, copy, open notepad++, paste, save, close, copy the address of XML saved file and paste in Tally. This will make my work easier.

[@rajeshshah6758]

Sub SaveasText() Private Sub SaveasText_click() Dim filename As String Dim lineText As String Dim my_range As Range filename = ThisWorkbook.Path & "\New File" & ".txt" Open filename For Output As #1 Set my_range = Worksheets("import sales").Range("3:D1430") For i = 1 To 1430 For j = 1 To 113 lineText = IIf(j = 1, "", lineText & ",") & my_range.Cells(i, j) Next i Print #1, lineText Next j Close #1 MsgBox ("Data transferred successfully") End Sub End Sub Sir I just copied your code and replaced the necessary text. But I am getting an error. Please let me know what is wrong

[@andyv3493]

i want to convert one column into different txt files

[@nelsonvalentinplaud2887]

This tutorial was very helpful as I'm new to VBA. I have a question though. How can I maintain the format of the text I'm exporting to notepad? Example: The data I'm exporting from Excel has various types of formatting. Cost $ 15,453.14 Rate 7.8% Cost paid $ 14,242.02 GP $ (2,742.14)

[@ExcelDestination]

a little bit additioan\different would be required

[@nelsonvalentinplaud2887]

@@ExcelDestination I'd appreciate any help you can provide. Thanks

[@kartikgupta8218]

#1 is used for notepad, can we open notepad++ in a similar way since I need to save file as json?? Can anyone help

[@santoshkamala2750]

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

[@kmekta1514]

i want to transfer data automatically in Desktop application using VBA... how to do that

[@krplant1]

Hi I am getting an error in "Open filename For Output As #1 "

[@ryancollado2333]

how can I check certain values from text file using excel macro? thanks

[@ExcelDestination]

first, you can import data in excel.........and then check those values.

[@ryancollado2333]

@@ExcelDestination can you please send me the vb code to check the value from those text files? thanks

[@MariaRhonaPinto]

Tried using this code - since i have variable range each time - but there is no output file generated - what am i doing wrong please guide - ie my rows are variable but columns are fixed Set my_range = Worksheets("00833_F").Range("A1" & ":E" & lastrow) For i = 1 To lastrow For j = 1 To 5

[@vikasbhardwaj7885]

Nice video

[@ExcelDestination]

Thanks

[@benedictolandesca4991]

Can anyone help me vba code on how to convert an excel file text to column to text file?

[@singadishivu28]

Can we give fixed width to each Column and Amount should fall right side Can you please help me with Code?

[@vigneshravi4503]

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

[@ExcelDestination]

you can check another tutorial at : kzbin.info/www/bejne/i5TOp4t8hdKFga8

[@ByronUy]

Hi! How do i save the file to a different path and rename? :)

[@ByronUy]

Great video by the way!

[@jamalarif3104]

very usefull for me!!

[@ExcelDestination]

Glad to hear that!

[@bangkokbluescricketclub4693]

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

[@PernambucoMeuPaisOficial]

Vba exportar arquivos txt da planilha, código simples e objetivo

[@rajeshshah6758]

Sir, still I am not able to copy a range from excel to notepad++. Please send me a sample to understand and practice it.

[@ExcelDestination]

ok, let me check and see, if I have the original file. can you pls send me email at [e-mail]

[@srinivaspatro2364]

I need the data in txt file as "cell value"| How could I do this ?

[@ExcelDestination]

you can share your task at [e-mail]

[@pravinparab2500]

How can I remove commas in notepad

[@jaycrook1076]

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

[@ExcelDestination]

some additional code would be required.

[@BharathKumar-lp7mp]

Sir, How to skip empty cells in the loop

[@ExcelDestination]

you can use if condition

[@BharathKumar-lp7mp]

@@ExcelDestination thank you sir

[@haniesmielie4149]

can i know how to create automatically id. In that ID have number, month and year .. example : 001-0420. For the regular 001 (number) click next automatic 002. For 04 (month) next month automatically change 05. For 20 is the (year) when next year automatically changes 21. This means that this 001-0420 will change for every month, when next month will be 001- 0520. Please help me, i hope u guys can answer for my question

[@ExcelDestination]

for any excel vba support, write to [e-mail]

[@kinzaabid3786]

Sir how to convert Excel VBA file to 'C'

[@greglovern4160]

Why not just save as .CSV?? The file contents would be EXACTLY the same in this example, and unlike this code it would correctly handle cases where the cell contents included commas (by enclosing that cell's contents in doublequotes). If this code was used where a cell included a comma, you'd have a train wreck; opening it back up on Excel or other apps would result in data lining up under incorrect headers. The only difference would be that the filename extension would be csv instead of txt, but you can easily fix that, still in VBA, with the FileSystemObject aka FSO. Lots of simple tutorials on that.

[@blueskyhigh420]

KML is a one reason why not. The "save as csv" (comma delimited) function unfortunately wraps some lines in quotes that break the kml. Saving to TXT (tab delimited) does the same thing however. The only way I've found to save actual clean text is to save as space-delimited ".prn". Hope this helps somebody. 🙂