export to text file

  1. B

    Exporting Excel Sheet Column into a text file

    Hi All, I am trying to export the same two columns from each sheet in a workbook (for example A2:A500 and B2:B500). I need the columns from each sheet to be exported into separate files that I will be prompted to name. Also, the two columns have to be separated by one space in the text file...
  2. B

    Copy sheet to text file with specific template

    I want to copy sheet to text file with specific template, I defined a range but the problem is my code begins in A3 instead of A2 and don't stop to LastRow so it bring empty rows and skippes even numbers it means rows A2, A4,A6... not copied Option Explicit Sub txtFile() Dim strPath As...
  3. J

    Create individual Text file from each Excel 2003 row using Macro

    Hello !! I am completely new to VBA. Can someone from community help me achieve following. I have an excel 2003 worksheet with three columns data as follows: <tbody> SYMBOL LISTING_DATE FV 20MICRONS 06-Oct-08 5 3IINFOTECH 22-Apr-05 10 3MINDIA 13-Aug-04 1 8KMILES 29-Jan-14 10...
  4. A

    export to text file from excel at fixed positions

    Hello, I have got a code from one of the threads on Mr.Excel, but that code fails when it encounters a blank cell in a row and it add that value in the wrong position in the text file. What i want is even if a blank cell is found ,the next cell value should be at the correct specified position...
  5. S

    Excel to text

    i have a excel file which I want in .txt output. In EXCEL sheet1 A1 contains number, B1 contains name, C1 contains Amount, D1 contains particulars. When I run Macro in text file to be created. In text out put I want spacing for A1 data is 14 {the account number varies from 5 digit to 14...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top