powermacros.blogspot.com
Power Macros: September 2011
http://powermacros.blogspot.com/2011_09_01_archive.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Thursday, September 8, 2011. In the last post. Upgrading my VBA code to work in Excel 201...
powermacros.blogspot.com
Power Macros: Throw More Hardware At It
http://powermacros.blogspot.com/2011/07/throw-more-hardware-at-it.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Tuesday, July 12, 2011. Throw More Hardware At It. The new machine is a Dell Latitude E55...
powermacros.blogspot.com
Power Macros: Database integration using object classes
http://powermacros.blogspot.com/2011/04/database-integration-using-object.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Wednesday, April 20, 2011. Database integration using object classes. I created classes f...
powermacros.blogspot.com
Power Macros: April 2012
http://powermacros.blogspot.com/2012_04_01_archive.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Thursday, April 12, 2012. As our models take on more and more of a mission-critical role,...
powermacros.blogspot.com
Power Macros: January 2012
http://powermacros.blogspot.com/2012_01_01_archive.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Thursday, January 12, 2012. The Hidden Corners of Excel Hold Many Secrets. Hinder progres...
powermacros.blogspot.com
Power Macros: The Hidden Corners of Excel Hold Many Secrets
http://powermacros.blogspot.com/2012/01/hidden-corners-of-excel-hold-many.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Thursday, January 12, 2012. The Hidden Corners of Excel Hold Many Secrets. Hinder progres...
powermacros.blogspot.com
Power Macros: Maintenance-Free Solutions
http://powermacros.blogspot.com/2011/11/maintenance-free-solutions.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Tuesday, November 8, 2011. 1 Keep it simple - this is obvious, but basically, the less co...
powermacros.blogspot.com
Power Macros: Hard Lessons
http://powermacros.blogspot.com/2011/09/hard-lessons.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Thursday, September 8, 2011. In the last post. Upgrading my VBA code to work in Excel 201...
powermacros.blogspot.com
Power Macros: More New Beginnings
http://powermacros.blogspot.com/2012/12/more-new-beginnings.html
A professional Excel VBA programmer shares some hard-learned pearls of wisdom gleaned from many years of Excel Application Design and VBA Coding. Topics include (but are not limited to): Design Methodologies, Coding Techniques, Undocumented Features, Work-arounds, Performance Optimization, Client Expectation Management, Documentation Strategies, Market Saturation, Code Reuse, and Work-from-home lifestyle advantages. Wednesday, December 19, 2012. A while back I spoke disdainfully. This friend had tried to...
