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" wrote in message
...
| 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" wrote in message
| ...
| |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!
|
|
|