excel to .txt

  1. L

    How to use Visual Basic to generate .txt file

    Could you help me to create the .txt file from the Excel spreadsheet. What Visual Basic code would I use? The correct format to use for the text file is: Document Number + Tab Key + Amount (with a decimal point and no dollar sign) + Enter Key. Repeat for each request I need to process. Text...
  2. D

    Exporting data to Text (Tab Delimited)

    Hi All, I am Trying to export a particular sheet to Text (Tab Delimited) File. The path to save the file and the name of the text file should be selected by the user. I tried searching in internet and i am Fed up on this. I tried the below code but the whole workbook is getting saved in the...
  3. N

    Write Array to txt.file (macro)

    Hi, I am having problems getting my array to write to a txt.file correctly. What it does currently, is display the results in a msgbox so we can see it straight away, and writes only some of the data that appeared in that msgbox into the txt.file. I tried using 'Append' which does display all...
    • NatWally
    • Thread
    • array data excel to .txt txt.file write to txt file
    • Replies: 0
    • Forum: Excel Questions
  4. R

    Saving a Dynamic Range as a .txt file

    Hello All, I have done some searching/experimenting and have been unable to find an adequate solution for my problem. What I would like to do is use a macro to copy a range of cells (N7:N####, where the value of #### is defined in cell O7) into a text file that uses the current date as the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top