save as txt

Objective: I want to export a known range of Cells to a .txt file with the click of a command button. I want the file to be automatically saved with the name as the value of a cell (A12) I already did some research and was able to slightly change an existing code I found that someone created to...

Hi, I'm still new to VBA and can't figure this one out. I work with txt files that I open with Excel (2010 on Windows). I need to accomplish the following steps: 1. Save the workbook as xlsx file, to the same location where the txt file currently was. No name change is needed, just the file...

Hello everyone, I have a spreadsheet that uses a macro to automatically save several tab delimited text file. It appears to be working great. The problem is, the text file has line breaks in it that are not in the data (sometimes even mid-word). I have turned off the macro and saved the file...

Hi my gurus of excel! I need to take the text string from a range of cells and put it into a text file (.html) as an exact copy with no added extras. Am I missing a simple solution? (I hope so) I've tried fileformat xltextprinter, this only seems to copy a very small amount of text...

Is there something inherent in saving as tab delimited text that adds an extra space at the end of the text? My code below works as I want, but the file created as text invariably has an extra space at the end. I know the answer is something incredibly simply, but I'm stumped?! When I...

I have a spreadsheet containing numeric and alpha numeric data that needs to be converted to text before I can use it in my printer software. The only way I can get it to work is to save the spreadsheet as a text file, and then import that file into excel, marking the column as text in the...