Cannot run Macro created in 2003

[Gizmo]

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!

 

[Jim Rech]

Check Tools, References in the VBE with this project active and see if
anything is marked 'missing'.

--
Jim
|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!

 

[Gizmo]

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]

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
| 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
| > | > |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!
| >
| >
| >

 

[Gizmo]

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