Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot run Macro created in 2003
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot run Macro created in 2003
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot run Macro created in 2003
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot run Macro created in 2003
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! | | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot run Macro created in 2003
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! | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros created in 2003 won't work in 2000 | Excel Discussion (Misc queries) | |||
Macros won't work in 2000 that are created in 2003 | Excel Discussion (Misc queries) | |||
will macro created in excell 2003 work if run using 2000 | Excel Discussion (Misc queries) | |||
Toolbars Created in Excel 2002 not available in 2003 | Excel Discussion (Misc queries) | |||
How do I remove a "List" once I've created it in 2003 | Excel Discussion (Misc queries) |