none
Suppress 3rd pary activex alert on Excel64 RRS feed

  • Question

  • Hi All,

    I have a macro with two forms, one has grid (3rd party control) to use in Excel 32, other form has just text boxes to display and edit values.

    If user is working on 32 bit, I show the grid but if he is working in excel 64 , I show the text boxes. 

    My problem here is that when I use the macro on Excel 64 bit, I get a message displaying something like 'Couldn't load the  object because it's not available on this machine.'

    I just want to hide or ignore this error. Request you please save some time for me. I'm working on it from moringin but not able to solve.

    Respectfully,

    Manoj


    Friday, January 22, 2016 5:35 PM

All replies

  • Re:  ignore error

    It is usually best to write code that doesn't error when tested;  It can only get worse when it goes into the wild.
    But...
    '---
    On Error Resume Next
     'quirky code line here
    On Error GoTo 0

    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)
    • Edited by James Cone Tuesday, October 25, 2016 1:33 AM
    Saturday, January 23, 2016 5:04 AM
  • If you want only to ignore the error use :

    On Error Resume Next

     If you want to be really profi you need to find the reason for having this error and solve it.
    Success


    Thanks in advance, Ciprian LUPU

    Saturday, January 23, 2016 10:11 AM