http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&u=5710Search results by user ID 5710en-USCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/p/3574/13656.aspx#13656Wed, 12 Sep 2012 00:44:45 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:13656Loren<p><span style="overflow:hidden;"></span>Hello,</p> <p><span style="overflow:hidden;"></span></p> <p>I&rsquo;m trying to test out using VBA and Excel to get at the data in Method. I&rsquo;m getting stuck early on!</p> <p><span style="overflow:hidden;"></span></p> <p>I downloaded the samples you have online (<a href="http://www.methodintegration.com/documentation/MethodAPISample_VBA.zip">http://www.methodintegration.com/documentation/MethodAPISample_VBA.zip</a>). I made sure the user I was on had permission to use the API and installed Microsoft Office XP Web Services Toolkit 2.0, per your instructions. (I&rsquo;m running excel 2010 &ndash; don&rsquo;t know if that makes a difference.)</p> <p><span style="overflow:hidden;"></span></p> <p>When I hit the button to run any of those macros, I get error 429 (&ldquo;ActiveX component can&rsquo;t create object&rdquo;).</p> <p><span style="overflow:hidden;"></span></p> <p>Any suggestions?</p> <p><span style="overflow:hidden;" id="mce_0_start"></span>Loren</p>