MACRO is working now, but I need to edit each page by:
Selecting Column A
Using tools:
Data
Text to Columns
Delimited
'clear' TABS & Select COMMA

Can I imput this function into the MACRO and how? I'm not great at working
Macros.

EricB

"EricB" wrote:

Importing multiple lines into Excel from txt. or MSWord

I have data comprising of some 325.000 rows, naturally .csv on allows a
little over 65.000.
How can I imports or paste data from txt. or Word into EXCEL that the
program creates more than one page to accept all the data.

The macro on http://redirx.com/?33qf gave me an €œout of memory result.

Regards

EricB