+ Reply to Thread
Results 1 to 5 of 5

Problem with Macro Recorder

  1. #1
    Registered User
    Join Date
    07-20-2007
    Posts
    2

    Problem with Macro Recorder

    I cannot get the macro recorder to record code for opening or saving files, whether they are text files or excel files. I know it should be able to do this as I accomplished this a couple of years ago, and everything I have read says I can do this.

    Essentially, I start the recorder, then open a file or save one. I stop the recorder. On opening the macro, I just get a blank macro.

    Am I being stupid here?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Just recorded this, you should be able to do the same.

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,706
    Did you go back to the original workbook that you recorded the macro in

  4. #4
    Registered User
    Join Date
    07-20-2007
    Posts
    2

    Thumbs up

    Thanks for the responses everyone. I tried to record the Macro on a different computer... and it worked no problem. I can only assume the old computer I use at work is gradually rotting away. The only other thing it could be is that I use Excel 2002 at work and 2003 on the computer I successfully recorded the macro with, but I don't think this is the issue from what I have read.

    nk_101

  5. #5
    Registered User
    Join Date
    08-29-2012
    Location
    South Yorks, England
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Problem with Macro Recorder

    I had a similar experience to you; remembered recording a macro which opened various programs etc only to find I couldn't do it later - apparently Windows used to provide such a recorder as standard but don't anymore. This means that as soon as you are beyond what is possible in excel (or presumably word, outlook etc) it is unable to record. If anyone can recommend a good replacement for the Windows macro recorder then I would be grateful to hear from them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1