Getting away from SENDKEYS

I’ve imported a series of perhaps 59,000 records.

My job now is to normalize the data for later import into MSACCESS.

Not only are records variable length, they are also multiple line!

No problem.

First field of each record has a unique string.

Unfortunately, some “A” COLUMN entries were interpreted as formulas.

My IF’s bomb out whenever they run across this trash.

I could build more security into the IF yet since I must deal with this RIFF-RAFF later, choose to set the COLUMN to text and then line-by-line process it into TEXT.

PHASE ONE:

1) Set VARIABLE to search string
2) Determine last row.
3) Set COLUMN A to format TEXT
4) Use FOR/NEXT to assume each cell as TEXT. Used SendKeys "{F2}{ENTER}", 1

As I have an enormous amount of data, this procedure is quite time consuming.

I WANT TO GET AWAY FROM SENDKEYS!!! Not only is it easier for others my logic (and therefore undermine my importance), It acts on the entire windows environment.

I cannot do anything else while this macro is running.

PHASE TWO consolidated all information.

PHASE THREE will combine multiple records

PHASE FOUR will remove unneeded data.

PHASE FIVE will ‘probably’ parse data into more manageable chunks for data transport into ACCESS.

So, how do I get away from SENDKEYS?

I must EDIT (using F2) and then hit ENTER.

Bill