iamtwilks
05-27-2011, 07:27 AM
Hi friends,
I have a new windows 7pc running Excel2003 but with a version of Excel2010 also installed.
Since the new pc install etc, a particular macro will no longer work.
i get the following error:
Run-time error '429':
ActiveX component can't create object.
the piece of code that generates this is:
set outapp = createobject("outlook.application")
any ideas on why this is tripping over now would be greatly appreciated.
i am guessing it has something to do with the object library referencing. I have checked the Available references and they tie back to the previous PC that had a working version of this macro on it.
Many thanks in advance for taking the time to look at the post.
kind regards
wilks:banghead:
I have a new windows 7pc running Excel2003 but with a version of Excel2010 also installed.
Since the new pc install etc, a particular macro will no longer work.
i get the following error:
Run-time error '429':
ActiveX component can't create object.
the piece of code that generates this is:
set outapp = createobject("outlook.application")
any ideas on why this is tripping over now would be greatly appreciated.
i am guessing it has something to do with the object library referencing. I have checked the Available references and they tie back to the previous PC that had a working version of this macro on it.
Many thanks in advance for taking the time to look at the post.
kind regards
wilks:banghead: