Microsoft Excel Macro: Bulk Reading and Writing First Line and Rest of File : <p>I am trying to make a macro that will bulk perform on all .txt files in a given directory. I would like the first line to be copied into the first cell (A1). And then I would like the rest of the contents to be pasted into B1. </p>

<p>The macro would perform that for all the .txt files in a directory, except it would go to A2, B2...A3,B3 etc</p>

<p>Can anyone help?</p>
