More information about Sergio's talk:Sergio will talk in relation to these notes. His aim is to continue to show how to use the tools in Excel/Excel VBA and use the Excel Object Model using intellisense to write VBA statements. Once you know how it is all done, your imagination will guide you as to how to apply the knowledge.
The entry barrier to VBA is knowing what you need to do. Excel VBA is a Microsoft product not easily beaten by others. ..........................................................................................................................................................................................................Sergio will bring some texts for persusal by members and will answer any questions arising from the information on the following sites or questions from members at the meeting including some examples - to be guided at the time.
.......................................................................................................................................................................................................... Please browse through these sites if you have time. 1. List of VBA lessons http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch2. This is Lesson1 of a list of VBA lessons (Shown in Point1 above) http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=302
3. Easy Examples..(This is lesson2) etc etc http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=315 4. Excel Objects - really good example descriptions. http://www.xlpert.com/partC.htm http://www.xlpert.com/partB.htm http://www.xlpert.com/partA.htm 5. Very Good easy description from Microsoft - optional if you print.http://visualbasic.about.com/gi/o.htm?zi=1/XJ&zTi=1&sdn=visualbasic&cdn=compute&tm=21&gps=636_409_1220_621&f=00&su=p284.9.336.ip_p504.1.336.ip_&tt=29&bt=1&bts=1&st=24&zu=http%3A//msdn.microsoft.com/library/default.asp%3Furl%3D/library/en-us/odc_xl2003_ta/html/odc_super.asp
<http://visualbasic.about.com/gi/o.htm?zi=1/XJ&zTi=1&sdn=visualbasic&cdn=compute&tm=21&gps=636_409_1220_621&f=00&su=p284.9.336.ip_p504.1.336.ip_&tt=29&bt=1&bts=1&st=24&zu=http%3A//msdn.microsoft.com/library/default.asp%3Furl%3D/library/en-us/odc_xl2003_ta/html/odc_super.asp>6. Easy to read on VBA code. At least browse and Sergio can go over any lines you may need to have explained.
http://www.codeforexcelandoutlook.com/blog/2009/04/excel-tutorial-series-vba-macros-part-one-of-two/ 7. Very Good and Easy explanation. http://vbcity.com/forums/t/112764.aspx 8. Interesting examples http://spreadsheetpage.com/index.php/tip/C16/ 9. Invisible Objects in Excel http://blogs.msdn.com/excel/archive/2009/01/30/hidden-and-invisible-objects.aspx 10. Excel Obj Model Wrapper http://www.freevbcode.com/ShowCode.asp?ID=1729 11. Interacting with other Excel Apps - an excellent resource http://peltiertech.com/Excel/XL_PPT.html 12. Office VBA macros you can use today. This is a text that has heaps of examples.There are a number of pages associated with this webpage - get the 130+ examples....
http://www.mrexcel.com/officevba/index.html 13. The single best book - beginner's perspective http://spreadsheetpage.com/index.php/book/excel_2003_power_programming_with_vba/ 14. The single best book absolutely - beyond beginner http://www.amazon.com/Microsoft-Excel-VBA-Professional-Projects/dp/1592000657