+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 Recorded Macro Results in Gibberish

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    NH, USA
    MS-Off Ver
    2010 & 2013
    Posts
    38

    Exclamation Excel 2007 Recorded Macro Results in Gibberish

    So... Here I am, trying to record a macro. When I go to clean up the code, I get absolute gibberish. I went back and recorded a simpler macro (running a sort on the range B2:D32) to give you guys this sample code. Note that this is copy-pasta direct from the VBA editor into this window. I have changed nothing.
    Please Login or Register  to view this content.
    The obvious question is "Where did all those 'VB_VarUserMemId' bits come from?" followed by "Where'd all the + and <= come from?" I know what the code is supposed to look like, and could fix it by hand... but has anybody else seen this behavior?

    The only oddball thing I can think of that might cause this is the fact that I had Office 2010 Technical Preview installed on this machine very briefly. It broke a few important spreadsheets, so I reported the bugs, then uninstalled it and went back Office 2007 SP 2. Is there a chance that it mangled some sort of macro- or VBA-related component?

    Any thoughts would be appreciated.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Excel 2007 Recorded Macro Results in Gibberish

    That's seriously hosed.

    You could try the diagnostics (2007's version of Detect & Repair) or reinstall.
    Entia non sunt multiplicanda sine necessitate

+ 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