Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
I had a 60-day Office Home & Student 2007 installed on my laptop, and I
installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
How did you declare appWD?
Did you use: dim appWd as Word.application or if you unchecked that reference (you may have to modify other portions of your code): dim appWD as Object Orion Cochrane wrote: I had a 60-day Office Home & Student 2007 installed on my laptop, and I installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
I ran into very similar issues between Office 2000 and Office 2007. Macros
created in 2007 may not function completely in older versions. I am starting to write macro for a living. To support most of my clients, I had to downgrade from office 2007 to office 2000. It sucks. Dennis "Orion Cochrane" wrote in message ... I had a 60-day Office Home & Student 2007 installed on my laptop, and I installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
I did use what you said. It worked for a year on my home computer. It worked
on my laptop here too. The only unusual thing I did between a couple of days ago and yesterday was uninstall Office 2007. It still works on the home computer. Do I have to reinstall Office 2003 to get it to work? My other reports work, as they are based in Excel. -- I am running on Office 2003, unless otherwise stated. "Dave Peterson" wrote: How did you declare appWD? Did you use: dim appWd as Word.application or if you unchecked that reference (you may have to modify other portions of your code): dim appWD as Object Orion Cochrane wrote: I had a 60-day Office Home & Student 2007 installed on my laptop, and I installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
What did you do?
Did you use the first declaration and have a reference to Word 11? Or did you use the late binding and discard any reference? ========== In the first case, I'd try reregistering xl2003. Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Orion Cochrane wrote: I did use what you said. It worked for a year on my home computer. It worked on my laptop here too. The only unusual thing I did between a couple of days ago and yesterday was uninstall Office 2007. It still works on the home computer. Do I have to reinstall Office 2003 to get it to work? My other reports work, as they are based in Excel. -- I am running on Office 2003, unless otherwise stated. "Dave Peterson" wrote: How did you declare appWD? Did you use: dim appWd as Word.application or if you unchecked that reference (you may have to modify other portions of your code): dim appWD as Object Orion Cochrane wrote: I had a 60-day Office Home & Student 2007 installed on my laptop, and I installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch
The Dim appWD as Object worked perfectly! You are a lifesaver!!!
-- I am running on Office 2003, unless otherwise stated. "Dave Peterson" wrote: What did you do? Did you use the first declaration and have a reference to Word 11? Or did you use the late binding and discard any reference? ========== In the first case, I'd try reregistering xl2003. Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Orion Cochrane wrote: I did use what you said. It worked for a year on my home computer. It worked on my laptop here too. The only unusual thing I did between a couple of days ago and yesterday was uninstall Office 2007. It still works on the home computer. Do I have to reinstall Office 2003 to get it to work? My other reports work, as they are based in Excel. -- I am running on Office 2003, unless otherwise stated. "Dave Peterson" wrote: How did you declare appWD? Did you use: dim appWd as Word.application or if you unchecked that reference (you may have to modify other portions of your code): dim appWD as Object Orion Cochrane wrote: I had a 60-day Office Home & Student 2007 installed on my laptop, and I installed Office Standard 2003. Running 2 versions of Office gave me problems when I clicked on an Office 2007 program (any file I opened started in 07, not 03). So I uninstalled the Trial version, and am now running on 03. I have an application that generates a report in Word, and now it gives me as Type Mismatch error on the following line: Set appWD = CreateObject ("Word.Application") It worked prior to uninstalling Office 2007. I have a reference to the Word 11.0 Object Model, so what's the problem? -- I am running on Office 2003, unless otherwise stated. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
13 type mismatch help | Excel Programming | |||
Type mismatch | Excel Programming |