$$Excel-Macros$$ Save a File From a Macro as a TXT file without an File Extension

2011-11-22 Thread TomR
Hi, all. I'm trying to save a file that I modified in a macro as a text file without an extension (.txt). Is that possible? I'm able to save the file as a text file, but it appends the file extension (.txt). Thanks, Tom -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

$$Excel-Macros$$ Incrementing Row by 1 in a Variable

2011-11-22 Thread TomR
Hi all, I'm new to the group and pretty new to Excel/VBA programming; learning while drowning. I'm building a macro to convert a text data/configuration file with data from an Excel spreadsheet. I'm using a variable that references a cell where I'm getting the first portion of my data from. I'm us