Results 1 to 4 of 4

Thread: Error Messages: User-Defined Type Not Defined

  1. #1

    Error Messages: User-Defined Type Not Defined



    Register for a FREE account, and/
    or Log in to avoid these ads!

    When I am running the Excel spreadsheet with VB macro I get the following error when running Excel 2010. However it works fine when running Excel 2007.
    Click image for larger version. 

Name:	Capture3.PNG 
Views:	84 
Size:	38.7 KB 
ID:	650

    I can not figure out what it is trying to reference or what I am missing.

    Thanks
    Lino

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    If you go into the VBE and go to Tools-->References in Excel 2010, you'll see that one is listed as "missing". Go back to Excel 2007 and check there to see which it is. From there you should be able to select it in Excel 2010 and that should solve your issue.

    Out of curiosity, is this on the same or different computers? I'm assuming different ones?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thanks for the information. Found out that it is still trying to reference msxml.dll version 2. This is no longer being used when running on Win7 using Excel 2010, Had to copy the msxml.dll file to the System32 folder and seems to be working fine now.

    Thanks
    Lino

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Excellent, glad you're sorted.

    Weird though... normally the compatibility going forward is pretty good. Obviously not so much in the xase of the msxml libraries.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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