+ Reply to Thread
Results 1 to 2 of 2

VBA run time error 32809 in some laptops

  1. 06-09-2015, 06:03 PM #1
    ElTopoMarinero
    ElTopoMarinero is offline
    Registered User
    Join Date
    04-30-2015
    Location
    Sugar Land
    MS-Off Ver
    2013
    Posts
    1

    VBA run time error 32809 in some laptops

    I created a xlsxm with some userforms and considerable automation. The file works fine in my work and home laptops and some of my peers laptops at work. Now some other folks are getting a Run-Time error '32809' Application-defined or object-defined error message.

    When tracing the code I was able to pinpoint the issue with a specific Tab (named "Data Sets" which I already renamed to "DataSets"). I also replaced references on Sheets("Data Sets") for Sheet6 - This latest step made Excel crash on the folks whom had the 32809 error.

    Additional input on Error 32809 is vague. As far as I have been able to investigate, is generated by a Microsoft update that was delivered back in December 2014. (See https://social.msdn.microsoft.com/Fo...forum=exceldev).

    Any idea on how can I fix this issue other to point corruption in this Data Sets tab?
    Reply With QuoteRegister To Reply
  2. 06-09-2015, 07:05 PM #2
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA run time error 32809 in some laptops

    There has been a few people with similar issues over the past week or so. One common issue, especially if using ActiveX, is that the Sheet, Workbook, UserForm etc., names are being "reversed" so to speak in their code. Meaning that "Data Sets" or "DataSets" becomes "Sets Data" or "SetsData". Check your code on the problematic laptops and see if this might be part of the issue. Check the code closely, this may not be the only wording that has been changed in the code. No idea why it is happening, but I have helped a couple of people with it in the past week.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run-Time 32809 Error causing havok - what's a workaround?
    By luger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2015, 11:47 AM
  2. Run-time Error 32809: Application-defined Or Object-defined Error
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 08:05 AM
  3. Help !Run-time error 1004 - Document not saved - ONLY showing on 32bit windows 7 laptops!!
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2014, 10:12 AM
  4. Working Code Suddenly Broken: Run-Time Error '32809'
    By Tirren in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-03-2014, 04:36 AM
  5. [SOLVED] Run-time Error 32809: Application-defined or object-defined error
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 04:15 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1