PC Review


Reply
Thread Tools Rate Thread

Cannot run Macro created in 2003

 
 
Gizmo
Guest
Posts: n/a
 
      16th Jun 2008
I am getting a compile error when I run a macro created in excel 2003. It is
the user form initialize code. Any of the initialize codes that contain Date
info error when trying to open the files or userforms. The code works fine in
excel2003. and other forms initialize ok as long as there is no reference to
Date in the forms code. I have checked the forums and found a reference to
the eurotool.xla. It is unchecked as per the advice from Tom Ogilvy. Its
still not working. Please help!
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      16th Jun 2008
Check Tools, References in the VBE with this project active and see if
anything is marked 'missing'.

--
Jim
"Gizmo" <(E-Mail Removed)> wrote in message
news:14C139B1-CAE4-444D-A4F4-(E-Mail Removed)...
|I am getting a compile error when I run a macro created in excel 2003. It
is
| the user form initialize code. Any of the initialize codes that contain
Date
| info error when trying to open the files or userforms. The code works fine
in
| excel2003. and other forms initialize ok as long as there is no reference
to
| Date in the forms code. I have checked the forums and found a reference to
| the eurotool.xla. It is unchecked as per the advice from Tom Ogilvy. Its
| still not working. Please help!


 
Reply With Quote
 
Gizmo
Guest
Posts: n/a
 
      16th Jun 2008
Hi Jim,

I had just finished downloading owc10.exe and owc11.exe from microsoft
website. They were both missing from the computer I was working on. I
installed both components and now the macro runs fine on 07. However....

When I try running the file on 2003 now I get the same error. I checked the
references and it says that Microsoft Word 12.0 Object Library is missing.
(I saved the file while in 2007)

I am going to try to download that one and see if my problems are over.

"Jim Rech" wrote:

> Check Tools, References in the VBE with this project active and see if
> anything is marked 'missing'.
>
> --
> Jim
> "Gizmo" <(E-Mail Removed)> wrote in message
> news:14C139B1-CAE4-444D-A4F4-(E-Mail Removed)...
> |I am getting a compile error when I run a macro created in excel 2003. It
> is
> | the user form initialize code. Any of the initialize codes that contain
> Date
> | info error when trying to open the files or userforms. The code works fine
> in
> | excel2003. and other forms initialize ok as long as there is no reference
> to
> | Date in the forms code. I have checked the forums and found a reference to
> | the eurotool.xla. It is unchecked as per the advice from Tom Ogilvy. Its
> | still not working. Please help!
>
>
>

 
Reply With Quote
 
Jim Rech
Guest
Posts: n/a
 
      17th Jun 2008
I think you need to have Word installed. If you do, uncheck the reference
to the Word 2007 version and try to connect to the 2003 version.

--
Jim
"Gizmo" <(E-Mail Removed)> wrote in message
news:F0D8FD9D-D4A7-48E2-A89C-(E-Mail Removed)...
| Hi Jim,
|
| I had just finished downloading owc10.exe and owc11.exe from microsoft
| website. They were both missing from the computer I was working on. I
| installed both components and now the macro runs fine on 07. However....
|
| When I try running the file on 2003 now I get the same error. I checked
the
| references and it says that Microsoft Word 12.0 Object Library is missing.
| (I saved the file while in 2007)
|
| I am going to try to download that one and see if my problems are over.
|
| "Jim Rech" wrote:
|
| > Check Tools, References in the VBE with this project active and see if
| > anything is marked 'missing'.
| >
| > --
| > Jim
| > "Gizmo" <(E-Mail Removed)> wrote in message
| > news:14C139B1-CAE4-444D-A4F4-(E-Mail Removed)...
| > |I am getting a compile error when I run a macro created in excel 2003.
It
| > is
| > | the user form initialize code. Any of the initialize codes that
contain
| > Date
| > | info error when trying to open the files or userforms. The code works
fine
| > in
| > | excel2003. and other forms initialize ok as long as there is no
reference
| > to
| > | Date in the forms code. I have checked the forums and found a
reference to
| > | the eurotool.xla. It is unchecked as per the advice from Tom Ogilvy.
Its
| > | still not working. Please help!
| >
| >
| >


 
Reply With Quote
 
Gizmo
Guest
Posts: n/a
 
      17th Jun 2008
Hi Jim,

I had some code in the workbook that exported some data to a Word document.
(Changed it to create a new workbook instead) I removed the code and the
reference to Word 11.0. It seems to be working now in both 2007 and 2003 as
long as I save as 2003 when in 2007.

Thanks for your help

"Jim Rech" wrote:

> I think you need to have Word installed. If you do, uncheck the reference
> to the Word 2007 version and try to connect to the 2003 version.
>
> --
> Jim
> "Gizmo" <(E-Mail Removed)> wrote in message
> news:F0D8FD9D-D4A7-48E2-A89C-(E-Mail Removed)...
> | Hi Jim,
> |
> | I had just finished downloading owc10.exe and owc11.exe from microsoft
> | website. They were both missing from the computer I was working on. I
> | installed both components and now the macro runs fine on 07. However....
> |
> | When I try running the file on 2003 now I get the same error. I checked
> the
> | references and it says that Microsoft Word 12.0 Object Library is missing.
> | (I saved the file while in 2007)
> |
> | I am going to try to download that one and see if my problems are over.
> |
> | "Jim Rech" wrote:
> |
> | > Check Tools, References in the VBE with this project active and see if
> | > anything is marked 'missing'.
> | >
> | > --
> | > Jim
> | > "Gizmo" <(E-Mail Removed)> wrote in message
> | > news:14C139B1-CAE4-444D-A4F4-(E-Mail Removed)...
> | > |I am getting a compile error when I run a macro created in excel 2003.
> It
> | > is
> | > | the user form initialize code. Any of the initialize codes that
> contain
> | > Date
> | > | info error when trying to open the files or userforms. The code works
> fine
> | > in
> | > | excel2003. and other forms initialize ok as long as there is no
> reference
> | > to
> | > | Date in the forms code. I have checked the forums and found a
> reference to
> | > | the eurotool.xla. It is unchecked as per the advice from Tom Ogilvy.
> Its
> | > | still not working. Please help!
> | >
> | >
> | >
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
running a Macro in 2007 which was created in 2003 Simon Microsoft Excel Misc 8 23rd Apr 2010 05:31 AM
copy 2007 created macro to run in 2003 amaries Microsoft Excel Misc 4 18th Dec 2008 07:48 PM
How do I convert a macro that was created in 2003 Excel to 2007 Elizabeth Microsoft Excel Programming 8 22nd Oct 2008 01:29 AM
Powerpoint Macro created in Office 2003 Jerry Menard Microsoft Powerpoint 1 14th Mar 2008 08:47 PM
will macro created in excell 2003 work if run using 2000 =?Utf-8?B?TWljaGFlbCBTb2FyZXM=?= Microsoft Excel Misc 2 11th Sep 2006 05:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:31 PM.