R
Rebecca
Thanks for the reply!!! Apologies - I should have been
more specific.
I am trying to import (append) all these text files from a
specified folder into an excel spreadsheet. So far, I've
only been able to append these comma delimited files by
repetitively going to the bottom of the spreadsheet,
clicking "get external data" and going thru the import
wizard. I've tried to write a macro to do this by
modifying a recorded macro but I'm not a VB programmer and
can't get it to work. (Is there a way to have VB tell you
where the code errors are?) Perhaps I'm on the wrong
track...
Any further help would be GREATLY appreciated!!!
more specific.
I am trying to import (append) all these text files from a
specified folder into an excel spreadsheet. So far, I've
only been able to append these comma delimited files by
repetitively going to the bottom of the spreadsheet,
clicking "get external data" and going thru the import
wizard. I've tried to write a macro to do this by
modifying a recorded macro but I'm not a VB programmer and
can't get it to work. (Is there a way to have VB tell you
where the code errors are?) Perhaps I'm on the wrong
track...
Any further help would be GREATLY appreciated!!!