Greetings,
I get a message saying "run time error 458: variable uses an Automation type not supported in Visual Basic" when I run a project of mine. VB points out the cause of the error as a statement where I assign a MS Excel application object to a variable. I have added a reference to Microsoft Excel in my project.
I'm using Win NT 4.0 SP6. What could be the cause of the error message? How do I solve it?Code:Dim oXL As Excel.Application Set oXL = CreateObject("Excel.Application") ' Error 458![]()
Thanks in advance.




Reply With Quote