| Purpose of the macro
|
 |
| Picture 1: Macro's source code |
|
| - |
The macro imports lines of a text file to MS Excel (Excel) worksheet.
In Excel, using its functions, you can divide contents of each the line into columns.
|
|
| Source Code |
|
| - |
There is the source code of the macro in the picture 1.
|
| - |
The explanations about HeaderFooter macro
and the comments (in green) should describe well enough how the macro works;
no other explanations are shown here.
|
|
| UserForm |
|
| - |
The macro uses userform "Xl07c1", for a user to select, how many text lines to imported.
The lines will be imported to a workbook.
|
|
|
Download
|
|
| - |
You can download the macro's source code and userform (Xl07c1.frm) here.
|
|
| How to run it? |
|
|
| - |
Guidance on how to make an operational macro with the source code and the userform is
is here here ("Using the Macros").
|
|