text file from rows

  1. P

    Macro to export text file based on worksheet parameters

    Hi Macro Experts!!! I need help creating a macro that will save a range (F#:DD#) based on the supplier value in column C as a text file. I included a screenshot of what my spreadsheet set up looks like. I need a separate text file for each supplier (Column C) that contains all of the data...
    • PIERANDPORT
    • Thread
    • macro - autosave output excel to text file text file from rows
    • Replies: 6
    • Forum: Excel Questions
  2. T

    Converting Worksheets to Text File

    Hello Experts! I am trying to convert several of the worksheets in my workbook to text files. I tried saving each as a prn file, but some of the data was getting cut off. Next I tried this: 'loop worksheets one by one, open file "WkshtName.prn" as #1 for output and call: Sub...
  3. V

    Create a TXT file from contents in a XLSM file

    Hi Guys, I'm new to Excel with regards to Macros/VBA and hence need help to create a TXT file from the contents in a XLSM file. The user enters the information in an XLSM file as follows: <tbody> Company Name: CarSalesPtyLtd Code: CSPL04 VEHICLE NUMBER MAKE MODEL YEAR COLOUR ABC123...
    • VJ1985
    • Thread
    • create text file filename macro save location text file from rows
    • Replies: 1
    • Forum: Excel Questions

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