+ Reply to Thread
Results 1 to 4 of 4

Excel 32809 and VB issues

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Orlando
    MS-Off Ver
    Excel 2003
    Posts
    17

    Post Excel 32809 and VB issues

    - I have created a Spreadsheet with Macros, its purpose is for Agents to create quotes for their customers
    - This spreadsheet need to used on Agent computers (no 2 computers are using the same OS nor version of Excel)
    - Upon running macros, we keep on getting the error code of 32809, and some unexplainable syntax errors "Microsoft Visual Basic for applications, Compile error, Can't find project or library"
    - It works some times and not others
    - Note: if the Macros work "once" when the sheet is open, it will continue to run the same every time you open the same sheet

    What we have done to try to solve the issues.
    1. Assemble a Win 7 OS computer with Excel 2012
    2. Export the macros and re-import them
    3. Macro - copy to a txt file and bring them back in, one-at-a-time

    Any guidance would be helpfull. Not sure where to turn
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,057

    Re: Excel 32809 and VB issues

    That error is usually down to incompatible activex objects. In your case, I suspect it's the date time picker you are using.
    Rory
    I drink, and I know things

  3. #3
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,859

    Re: Excel 32809 and VB issues

    Additional possibilities (your profile says you are using Excel 2003):
    You have come across the 'Active X' incompatibility between Excel 2003 and later versions of Excel. This manifests itself with the following behavior:
    a. Excel 2003 files containing 'Active X' work fine in Excel 2007+ versions of Excel.
    b. Excel 2007+ files containing 'Active X' will generate an error when attempting to use VBA in Excel 2003. The runtime errors I usually see are 32809 and 57121.

    Unfortunately, the workaround I use is very ugly.

    When attempting to use Excel 2003 for a file containing 'Active X' created in Excel 2007+:
    a. Delete all the 'Active X' Controls on each Sheet.
    b. Make a copy of each sheet that had an 'Active X' control.
    c. Delete the original Sheets that had the Active 'X' controls.
    d. Rename the Copied Sheets back to the Name of the Original Sheets.
    e. Save the file. Close the File. Reopen the file.
    f. Recreate the 'Active X' controls.

    -----------------------
    The problem may also be related to corrupt .exd Office files. For more details see post #2 in https://www.excelforum.com/excel-pro...ml#post4810058

    Lewis

  4. #4
    Registered User
    Join Date
    04-07-2014
    Location
    Orlando
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Excel 32809 and VB issues

    I got the fix. some ot the computers had mad or missing mscomctl.ocx and comctl32.ocx files. It seems to have fixed the issue. thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. runtime error 32809
    By jonrack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2015, 11:07 PM
  4. Runtime error 32809 -> No solution on the web
    By RokFinzgar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2015, 09:58 AM
  5. Runtime error 32809
    By hinta in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-14-2015, 09:24 AM
  6. Errors 32809 and 57121 :-(
    By Jan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2009, 06:37 PM
  7. Error 32809 with ActiveSheet.Paste in Excel 1997
    By gjcase in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2009, 02:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1