LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to record Keystrokes instead of keystroke actions

Has Micorsoft ever added back the functionality of recording keystrokes
instead of keystroke actions?

I am trying to massage a large text file that I've brought into Excel.
Excel makes it easy to compare one file with another.

I record a macro to:
F2 to Edit a cell,
SHIFT + HOME to select all of the text in the cell,
CTRL-X to MOVE the text into the clipboard,
UP ARROW to get to the above cell,
F2 to edit this cell
CTRL+V to paste previously copied text to this cell
and ENTER to finalize this cell

When I play this back on the next pair of cells, either the concatentated
text of the forst cell ends up in the new cell, or the text that was in the
original first cell is copied to the end of the new second cell.

When I look at the Macro editor, I see not keystrokes but keystroke actions.
Seems like there was a script editor that use to do what I'm looking for,
but I guess Mr. Gates eliminated this many Excel versions ago.

Can any one help?

--
DonD'Cajun
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to record keystrokes ? Steve[_9_] Excel Discussion (Misc queries) 4 December 5th 07 02:44 PM
Getting macro to record keystrokes instead of cell contents dbe4876 Excel Programming 2 September 21st 05 04:05 PM
how to get a macro to record F2, Home, Delete keystrokes jenonstx Excel Programming 1 July 22nd 05 03:25 AM
Record Macro - Record custom user actions Sal[_4_] Excel Programming 1 December 23rd 04 03:18 PM
Record Keystrokes With Macro Recorder Minitman[_4_] Excel Programming 0 April 1st 04 09:40 AM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"