<story><title>Use Python in Excel without add-ins</title><url>http://xlwings.org/</url></story><parent_chain><item><author>mattfrommars</author><text>Might be irrevelant but anyone know best source to learn VB macros?</text></item><item><author>pge</author><text>This is fantastic - I am going to start testing it now. I write a fair amount of VB macros, and would much prefer to be able to use Python.&lt;p&gt;And, if they could create a plugin that allowed Libre Office to do the same, they could solve one of the last remaining major interoperability issues with LO and Excel: the inability to run VB macros in LO. That would be huge.</text></item></parent_chain><comment><author>pessimizer</author><text>Speaking specifically about Excel, the most important thing to learn is the Range object, no matter what book you&amp;#x27;re using:&lt;p&gt;&lt;a href=&quot;http://msdn.microsoft.com/en-us/library/office/ff838238%28v=office.15%29.aspx&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;msdn.microsoft.com&amp;#x2F;en-us&amp;#x2F;library&amp;#x2F;office&amp;#x2F;ff838238%28v=...&lt;/a&gt;&lt;p&gt;Close behind are Collections and UDTs. The best thing to level up after you&amp;#x27;re comfortable is with &amp;#x27;Implements&amp;#x27; for interfaces.&lt;p&gt;I found that search engines are as good as any book for this stuff. It&amp;#x27;s smeared all over the internet.&lt;p&gt;The &lt;i&gt;best&lt;/i&gt; place I know of to get a good understanding is &lt;a href=&quot;http://www.cpearson.com/excel/MainPage.aspx&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;www.cpearson.com&amp;#x2F;excel&amp;#x2F;MainPage.aspx&lt;/a&gt;, but it&amp;#x27;s not a tutorial.&lt;p&gt;edit: that&amp;#x27;s what I get for keeping this window open too long:) That&amp;#x27;s 2 votes for cpearson.com.</text></comment>
<story><title>Use Python in Excel without add-ins</title><url>http://xlwings.org/</url></story><parent_chain><item><author>mattfrommars</author><text>Might be irrevelant but anyone know best source to learn VB macros?</text></item><item><author>pge</author><text>This is fantastic - I am going to start testing it now. I write a fair amount of VB macros, and would much prefer to be able to use Python.&lt;p&gt;And, if they could create a plugin that allowed Libre Office to do the same, they could solve one of the last remaining major interoperability issues with LO and Excel: the inability to run VB macros in LO. That would be huge.</text></item></parent_chain><comment><author>agumonkey</author><text>When I had to spend a large amount of intimate time with VBA I used to go to&lt;p&gt;&lt;a href=&quot;http://www.cpearson.com/Excel/Topic.aspx&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;www.cpearson.com&amp;#x2F;Excel&amp;#x2F;Topic.aspx&lt;/a&gt;&lt;p&gt;&lt;a href=&quot;http://www.ozgrid.com/VBA/&quot; rel=&quot;nofollow&quot;&gt;http:&amp;#x2F;&amp;#x2F;www.ozgrid.com&amp;#x2F;VBA&amp;#x2F;&lt;/a&gt;&lt;p&gt;Old websites but in my case I dealt with Office &amp;lt;= 2003</text></comment>