Hi, could someone help me to write a macro to create text file from excel...?
here is my situation...
i have data filled from column A to column AG.
i need to export only certain columns of data from excel to a text format.
the data range is columns B, W, Z, AD, AE and AF.
there are data in several rows but the end row should be if column B becomes empty (no value in it).
text file saved to the desktop.
file name = "TRACKING" + date "yyyymmdd"