| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add-ins
Hi,
I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add-ins
Louie,
Make sure that your not missing any references. VBA window, toolsreferences. hth, Job "Louie" wrote in message ... Hi, I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add-ins
Hi Job,
Thanks, I appreciate your reply. I am very new to programming so pls understand my ignorance.. How can I tell what references is being used by the add-in, is there a way I can see it on the source code.. Whats a common reference with add-in in Excel. I have the following check on the reference list. Visual Basic Application Microsoft Excel 11.0 Object library OLE Automation Microsoft Office 11 Object library Ms Form 2 Object Library Ms Scripting Runtime Am I missing something else. thank you very much for your help. Louie "Job" wrote: Louie, Make sure that your not missing any references. VBA window, toolsreferences. hth, Job "Louie" wrote in message ... Hi, I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add-ins
looks like you have all the basic references. Is it possible that the
add-in your looking to use has an actual form associated with it that is no longer part of the addin? Perhaps the form was never a part of the addin, but in the personal.xls and it referenced that form? "Louie" wrote in message ... Hi Job, Thanks, I appreciate your reply. I am very new to programming so pls understand my ignorance.. How can I tell what references is being used by the add-in, is there a way I can see it on the source code.. Whats a common reference with add-in in Excel. I have the following check on the reference list. Visual Basic Application Microsoft Excel 11.0 Object library OLE Automation Microsoft Office 11 Object library Ms Form 2 Object Library Ms Scripting Runtime Am I missing something else. thank you very much for your help. Louie "Job" wrote: Louie, Make sure that your not missing any references. VBA window, toolsreferences. hth, Job "Louie" wrote in message ... Hi, I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add-ins
You are right, I remove the form code associated with this error and its
working fine now. Now as soon as I click the button on the form say button1. and has the following codes on it Private Sub cmdBrowse_Click() cmdlgFile.fileName = "*.*" cmdlgFile.Action = 1 If cmdlgFile.fileName < "" Then txtFileName.Text = cmdlgFile.fileName End If End Sub I am getting a Run-Time error 424; Object required. Do you have any idea what object should I cmdlgFile be? Thanks for working with me on this.. You are really helping me learn more on Excel programming. "Job" wrote: looks like you have all the basic references. Is it possible that the add-in your looking to use has an actual form associated with it that is no longer part of the addin? Perhaps the form was never a part of the addin, but in the personal.xls and it referenced that form? "Louie" wrote in message ... Hi Job, Thanks, I appreciate your reply. I am very new to programming so pls understand my ignorance.. How can I tell what references is being used by the add-in, is there a way I can see it on the source code.. Whats a common reference with add-in in Excel. I have the following check on the reference list. Visual Basic Application Microsoft Excel 11.0 Object library OLE Automation Microsoft Office 11 Object library Ms Form 2 Object Library Ms Scripting Runtime Am I missing something else. thank you very much for your help. Louie "Job" wrote: Louie, Make sure that your not missing any references. VBA window, toolsreferences. hth, Job "Louie" wrote in message ... Hi, I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add-ins
Look at all the objects on the form. Make sure your properties window is
open(in vba editor) and just click on all the objects on the form and the form itself to see what the name is referring too... "Louie" wrote in message ... You are right, I remove the form code associated with this error and its working fine now. Now as soon as I click the button on the form say button1. and has the following codes on it Private Sub cmdBrowse_Click() cmdlgFile.fileName = "*.*" cmdlgFile.Action = 1 If cmdlgFile.fileName < "" Then txtFileName.Text = cmdlgFile.fileName End If End Sub I am getting a Run-Time error 424; Object required. Do you have any idea what object should I cmdlgFile be? Thanks for working with me on this.. You are really helping me learn more on Excel programming. "Job" wrote: looks like you have all the basic references. Is it possible that the add-in your looking to use has an actual form associated with it that is no longer part of the addin? Perhaps the form was never a part of the addin, but in the personal.xls and it referenced that form? "Louie" wrote in message ... Hi Job, Thanks, I appreciate your reply. I am very new to programming so pls understand my ignorance.. How can I tell what references is being used by the add-in, is there a way I can see it on the source code.. Whats a common reference with add-in in Excel. I have the following check on the reference list. Visual Basic Application Microsoft Excel 11.0 Object library OLE Automation Microsoft Office 11 Object library Ms Form 2 Object Library Ms Scripting Runtime Am I missing something else. thank you very much for your help. Louie "Job" wrote: Louie, Make sure that your not missing any references. VBA window, toolsreferences. hth, Job "Louie" wrote in message ... Hi, I need help. I have an add-ins in EXCEL that used to work before but now its not working. I am using EXCEL 2003 as soon as I load the add-ins I got this message saying. Microsoft form "Could not load an object because it is not available on this machine" What object? is it some kind of a library that's not installed on my machine? Using Excel 2000 I am getting a different error message and said, Run-time error '430' Class does not support Automation or does not support expected interface. Can anyone help me please... Thanks. -- Louie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
