Dear Dave,

It works in Lotus but not here. I suspect that the macro recorder records
the results of the R2C wizard's evaluation of the data rather than the
keystrokes required to progress through the wizard. The recorded VBA
programs look like specific arrays that are data specific. When the recorded
macro is run against another set of different data the results are not
accurate. The recorder just does not record the keystrokes with Wizards.
My posted keystroke sequence works fine. It just gets tiring after doing it
for the 4 or 500th time in a row.
BTW I can record a macro for each different text string length and run a
macro for each row. This still means I have to key in something for each row.
The idea is to write a VBA program in a relative loop that duplicates the
keystrokes noted.

Pa

"Dave Peterson" wrote:

Why won't the macro recorder work?

It usually works ok for me when I record data|text to columns.

The only time I've seen any problem with an array is when I have lots and lots
of fields and get an "out of memory" error when I try to rerun the recorded
macro.

http://support.microsoft.com/default...EN-US;q134826&
XL: "Out of Memory" Message Using the OpenText Method



Parusky wrote:

Please help. VBA Ignorant. I am trying to build a macro to convert a lot of
fixed width data from text to columns sequentially for multiple rows. The
macro recorder will not work due its nature with arrays. The simple keyboard
commands that do work are as follows:
Alt D
Alt e
Enter
Enter
Enter
Arrow down
Got the books on VBA but can't seem to get started on this simple repetitive
onerous manual task. A keyboard recorder would be nice.

Thanks for your kind assistance

Parusky

--

Dave Peterson