Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Basingstoke, Hampshire, United Kingdom
    Thanked 0 Times in 0 Posts

    Macros (XL97/WinNT4)

    Can someone tell me how you record a macro so it actually records the keystrokes performed, not just the results of the keystrokes? I don't mean relative vs absolute recording, I know about that but it doesn't change this problem for me!

    Some of my users have a big spreadsheet where one column consists of hyperlinks, where the cell contains the name of the company and is hyperlinked to the document concerned. These currently start, eg "FALSEDATA..." and need to be changed to, eg "CORRECT01DATA..." but since the links are not in the cells in the normal way Ctrl-H can't see them.

    I therefore need to record the keystrokes, ie Insert, Hyperlink, go to left end of field (home), press delete 7 times, type "CORRECT01", click OK. When I do it, however, it just records "Selection.Hyperlinks(1).content = "CORRECT01DATAFOLDERFOLDERFOLDERDOCNAME.XLS" or whatever the name of the current link is.

    Since I don't want all the links pointing to the same document, this is no good!

    Is there a way to records keystrokes, please?

    Any help gratefully appreciated!
    Beryl M

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Macros (XL97/WinNT4)

    I do not think you can record the keystrokes.

    Perhaps the code in <post#=307979>post 307979</post#> will answer your "goal". It is a find/replace in all the hyperlinks in the sheet.


  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Macros (XL97/WinNT4)

    Excel's macros are VBA, not keystrokes. If the macro recorder recorded keystrokes, you could not do anything with it since there would be no way to play them back. To do what you want to do, you need to learn enough VBA to modify the recorded procedure.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts