Concatenate & Write to Text File
Excellent, works great JE. Quick question if I might, I'm trying to
stay away from using a selected range. Could I just use something like
this:
Dim rng1 As Range
Dim rng2 As Range
Dim rng3 As Range
Set rng1 = Range("A3", Cells(Rows.Count, 1))
Set rng2 = Range("C3", Cells(Rows.Count, 3))
Set rng3 = Range("D3", Cells(Rows.Count, 4))
And then maybe: sData = rng1 & rng2 & rng3
or something of the like?
Also, our computers are set up like this: C:\Documents and Settings
\username\Desktop, is there a way to have the txtfile output to the
users desktop without having to prompt for the directory?
Thanks again,
-- Dan
|