Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Macro vrs Function Macro Auto Start Pat Excel Discussion (Misc queries) 7 June 6th 07 09:53 PM
error : CANNOT START THE SOURCE APPLICATION FOR THIS OBJECT WORD USER Excel Discussion (Misc queries) 0 August 16th 06 04:20 PM
Error on start up... Louie Warren Excel Discussion (Misc queries) 2 May 17th 05 06:10 PM
Why do I get the runtime error message430 when I start my compute. Thorcat Setting up and Configuration of Excel 1 December 2nd 04 08:15 PM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 06:04 PM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"