Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

November 2011 - Daily Dose of Excel

Daily Dose of Excel

Home

Syndication

Recent Posts

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Sort by: Most Recent | Most Viewed | Most Commented

List all folders in a Microsoft Outlook account

Recently, I wanted to create a list of all the folders in my MS Outlook PST file together with the size of each folder. Outlook provides that information through the user interface. Unfortunately, it shows the result in a modal dialog with no way to save the information elsewhere. So, I decided [...] Read More...

Published Thu, Nov 03 2011 10:00 AM by Daily Dose of Excel

Filed under: VBA
How Much to Charge for Freelance VBA Development

$150 per hour. $120 per hour if the project is big enough that you won’t have to look for work for a while. $100 per hour if you’re really hungry. I’m sick of reading blog posts about how much to charge. They don’t tell me anything I don’t already know. And they [...] Read More...

Published Wed, Nov 02 2011 10:36 PM by Daily Dose of Excel

Filed under: General
Protect a global variable in another VB project

Developers who have done any kind of programming with the Office 2007 (and later) Ribbon architecture have encountered almost certainly a scenario that resulted in the loss of their pointer to the ribbon. This happens because the ribbon object has to be stored in a global variable and any kind of unhandled error leads [...] Read More...

Published Wed, Nov 02 2011 1:45 AM by Daily Dose of Excel

Filed under: Excel12, VBA, Fluent UI, Excel 14, Excel Basic, Excel Intermediate

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.