http://blog.activexls.com Your spreadsheet mastery resource Wed, 22 Nov 2006 16:48:25 +0000 http://backend.userland.com/rss092 en A quick and easy online guide to C#. Also comes with a short preview of the changes C# 2.0 brings. Learn CSharp http://blog.activexls.com/net/2006/free-book-learn-c/ CX NOW! is a powerful dashboard tool from BusinessObjects. Check out their demo. Prices start at 195$ http://blog.activexls.com/excel/2006/from-excel-spreadsheets-to-persuasive-presentations/ Neopoleon : Excel as a database "As a developer, you've probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of "data" by someone in marketing and told to "do something with it."" http://blog.activexls.com/excel/2006/excel-as-a-database-part-2/ "Bill Gates was amazingly technical. He understood Variants, and COM objects, and IDispatch and why Automation is different than vtables and why this might lead to dual interfaces. He worried about date functions. He didn't meddle in software if he trusted the people who were working on it, but you ... http://blog.activexls.com/excel/2006/a-tale-of-excel/ A short note from the author: Considerations for server-side Automation of Office "Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this ... http://blog.activexls.com/excel/2006/why-you-shouldnt-use-office-automation/ 5 reasons why Excel 2007 smokes the web2.0 competition... and why it may not matter is an interesting peak into the improvements Excel 2007 is supposed to bring in December. ZuluInSiliconValley points out Conditional Formatting More rows Previewing Ribbon and menu bars Charting vs Sharing Search http://blog.activexls.com/excel/2006/5-reasons-why-excel-2007-is-better-or-not/ "Why do people keep putting data in spreadsheets that obviously belongs in a database? Oddly enough, part of the reason came to me in a fairly unlikely place, reading to my kids before bed. We had just plopped on the couch to read a book when my kindergartener made me ... http://blog.activexls.com/excel/2006/excel-as-a-database/ Contextures.com shows how you can display different images based on an cell value input. Via DashBoardSpy http://blog.activexls.com/excel/2006/happy-face/ The course can be completed in one day, or over four separate sessions. Content includes four 75 minute lectures and four 30 minute labs. The actual ... http://blog.activexls.com/net/2006/net-university/ Excel has the ability to put code in three places. If the code is in a standard module the key to stopping the dialog is to remove the entire module(s), not simply delete the code in it. To do this: Open the VBE (Alt+F11) In the project explorer look for the name ... http://blog.activexls.com/excel/2006/remove-the-macro-security-warning/