Consulting

Results 1 to 3 of 3

Thread: run time error '438' - Object doesn't support this property or method

  1. #1

    run time error '438' - Object doesn't support this property or method

    Hi all,

    I have what looks like a compatibility problem between Excel 2003 and Excel 2007. The gist of it is that I spawn data from MS Access to MS Excel and kick off an Excel macro to do a LOT of formatting. When my users have Excel 2003 it halts the formatting macro and gives them the run time error '438' - object doesn't support this property or method. If my users have Excel 2007 then it completes successfully. Where the code halts is random so I can't seem to glean any knowledge from the location it fails. I'm sure this has to do with my vba references and the fact that I need to assign different ones for different versions of Excel. How do i figure this out? I tried to take a copy of the excel spreadsheet, assign Excel 2003 (Excel 11.0) references and run that but it still failed. Maybe it's something else? Here are the references I currently have:
    • Visual basic for applications
    • Microsoft Excel 12.0 Object Library (I tried replacing with 11.0)
    • OLE automation
    • Microsoft Office 12.0 Object Library (I tried replacing with 11.0)
    Any ideas?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,080
    Location
    You would need to show the code for us to make any headway on this.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Sure thing. I didn't post this originally because it's lengthy and the crash rarely occurs in the same place (if ever). It seems to crash most frequently within the EnterMTDFormulas subroutine (at bottom) but it rarely ever crashes on the same line. This is what leads me to believe it's a 'reference' issue between the two different versions of Excel.

    Code is in attached word document because for some reason the forum wouldn't accept my post with it pasted directly in.

Posting Permissions

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