I was able to get this live of code to work in Excel 2007.
After testing on another users system with excel 2007 it would not work. The software has been installed and everything appears to match my system.Well yesterday I was upgraded to a new laptop which no uses Win7 and Office 2010 and I'm now running into the same problem. Get ActiveX run time errors. I have unistalled, reinstalled, verified the reference is set, checked my IE options (activeX settings) - yet I still can't get this to connect. It works flawlessly on my old system but nothing but road blocks on others. Any suggestions on things to check?
Code:
Public SvcApp as Object
Set SvcApp = CreateObject("Svc.SporlanObject")
SvcApp.Visible = FalseAfter testing on another users system with excel 2007 it would not work. The software has been installed and everything appears to match my system.Well yesterday I was upgraded to a new laptop which no uses Win7 and Office 2010 and I'm now running into the same problem. Get ActiveX run time errors. I have unistalled, reinstalled, verified the reference is set, checked my IE options (activeX settings) - yet I still can't get this to connect. It works flawlessly on my old system but nothing but road blocks on others. Any suggestions on things to check?
