VBA and text files

youngda

Board Regular
Joined
Jun 13, 2006
Messages
81
I have a rather odd problem: I need to take a range of cells and paste it in a text document. After I paste the first range, I need to be able to paste similar ranges to that same text document on the line AFTER my previous pastes. If possible (or if necessary), I'd also like this to automatically save this text file as a preset filename.

Is it possible to work in this way with a txt? I have already written a similar function that performs the same thing for a CSV file, so I have those basics down, but before I get too deep in the Text file function I'd like to know if VBA even supports such a function.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,114,040
Messages
5,545,676
Members
410,697
Latest member
srishtijain0708
Top