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
|