Hi,
I was watching the Automated Text Import in Excel with File Selection - The Easy Way - VBA video tutorial and found it very helpfull. Now I am trying to add the next import at the end of the first import, so at the next free row.
The VBA states
"wbTextImport.Worksheets(1).Range("A1").CurrentRegion.Copy wsMaster.Range("A3")" which will replace the initial text instead of appending. I have found someting like
"Range("A" & Rows.Count).End(x1Down).Offset(1).Select.PasteSpecial" but I don't knwo how to combine it with the previuos one.
Any help is appreciated.
Thanks
Excelsior