Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have an error when a start my macro
I bring home one of my macro to continu working on it. But when I try to
start it, the system is giving me that error:" could not load an object because it is not available on this machine" what can be the problem???? that macro is working at work on excel 2000 but not workink at home on excel 2002 thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have an error when a start my macro
Hi Nicolas
one idea: you probably have to specify a reference in the VBE which is available at your work computer. You may post the specific lines of your macro that causes this error -- Regards Frank Kabel Frankfurt, Germany Nicolas boisjoly wrote: I bring home one of my macro to continu working on it. But when I try to start it, the system is giving me that error:" could not load an object because it is not available on this machine" what can be the problem???? that macro is working at work on excel 2000 but not workink at home on excel 2002 thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have an error when a start my macro
This is the section of the code where I'm falling when I try to debug:
------------------------------------------------------------------------- Private Sub CommandButton2_Click() Dialog1.Filter = "Spending Profile" Dialog1.Filename = "*.xls" Dialog1.ShowOpen donnee_classeur_path = Dialog1.Filename If Dialog1.Filename = "" Then Exit Sub TextBox1 = donnee_classeur_path End Sub -------------------------------------------------- "Frank Kabel" wrote in message ... Hi Nicolas one idea: you probably have to specify a reference in the VBE which is available at your work computer. You may post the specific lines of your macro that causes this error -- Regards Frank Kabel Frankfurt, Germany Nicolas boisjoly wrote: I bring home one of my macro to continu working on it. But when I try to start it, the system is giving me that error:" could not load an object because it is not available on this machine" what can be the problem???? that macro is working at work on excel 2000 but not workink at home on excel 2002 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
error : CANNOT START THE SOURCE APPLICATION FOR THIS OBJECT | Excel Discussion (Misc queries) | |||
Error on start up... | Excel Discussion (Misc queries) | |||
Why do I get the runtime error message430 when I start my compute. | Setting up and Configuration of Excel | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |