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.
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.