.txt file

  1. P

    VBA - Export Specific Column every 30 rows to .txt file

    Hi VBA Wizards, I have been battling to get this working. The purpose of this is that our customers need to enter a particular format to order in our b2b system. We have a problem with our ERP handling the .xml so limit the customer's orders in the b2b system to 30 lines per order. We would...
  2. R

    Create .TXT Subsets based on existing Excel data using VBA Macro

    Hello Guys, I need to create Subsets for the data which I have, which is dynamic, using Excel VBA. I have data in the form of table, whose column headings are Code, % & Transaction ID as the below table. Code % Transaction ID 1001 42.10% 455152 1001 42.10% 455153 1001...
  3. K

    Export to .csv or .txt --> Header gets messed up

    Hi There! I'm exporting my customer email list, along with additional customer info, from excel to .txt However, every single time I do the export the header gets messed up in the .txt document. The header labels do not line up with the data below the header. So for example the labels "email"...
  4. B

    Copying certain information from a text file using VBA code

    Is there a way to create a code to 1st read a specific .txt file based off of the .txt file's name listed in a certain cell in Excel and then enter that certain information from the .txt file below that .txt's file name in the very next row below the file name's cell? If so, could it search &...

This Week's Hot Topics

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
Top