Thread: How do I append imported text down an Excel Spreadsheet?

I have a macro that imports text file. But the when the macro runs the file
is imported accross the page. I need it to go down the page. This file is a
daily update of accounting information.

a) change the way the imported file is created so that it has one item per
record
b) do a Copy followed by Edit|Paste Special->Transpose in the worksheet
c) implement (b) as a subroutine macro
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jdicicco" <Jdicicco@discussions.microsoft.com> wrote in message
news:48417C6D-BB91-42A5-9578-DFF6D69BBFB6@microsoft.com...
>I have a macro that imports text file. But the when the macro runs the
>file
> is imported accross the page. I need it to go down the page. This file
> is a
> daily update of accounting information.