I am still struggling with the error “VBAProject - 430: Class does not support Automation…”. This is triggered by the line Set DesApp = New Designer.Application. I am using Excel 2007 on Vista. I also have Visual Studio 2005 installed with .NET Framework v3.5. I have local admin rights on my pc.
I have the correct references set under Tools - References. Intellisense works in the code and from the Object Browser I can see Application as a class in the Designer library.
I have tried the resolution in Solution to VBA error 430 Class does not support automation with no success.
It seems like Excel cannot connect to the correct dll to launch Designer at runtime. Any thoughts on what else I can check ?
margarita (BOB member since 2005-11-08)