简介：daily posts of excel tips...and other stuff

原站：http://www.dailydoseofexcel.com

标签：excel daily

指数：

“Daily Dose of Excel”的内容更新

累计：675 篇（自 2007-09-03 起）

更新：约3篇/周，最后更新105 天前

Daily Dose of Excel

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 to check if i could find some ready-to-use (or nearly ready-... (105 天前)

http://inezha.com/w/ygv95uxu

Daily Dose of Excel

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 never tell you how much to charge. you’re welcome.someone reading this post is chargin... (105 天前)

http://inezha.com/w/0ts6i5x2

Daily Dose of Excel

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 to a “loss of state,” which includ... (106 天前)

http://inezha.com/w/e2kk15x0

Daily Dose of Excel

Sorting a Custom Collection Class

i’ve been following dick’s vbhelpers build series (1, 2, 3) and his last post reminded me that, from time to time, i need to sort a collection of items in-memory.i don’t have to sort all that often, so my approach has changed over time. i’ve kind of settled on the following.let’s say i have a people collection that contains person items.in my per... (108 天前)

http://inezha.com/w/revc75xo

Daily Dose of Excel

VBHelpers Build 3

in this iteration, icreate a generator for a fillfromrange method of the parent classget rid of those unisightly blank lines when converting public variables to property statementschange findby to childby (thanks steve j)if i have a range of records that i want to put in a class, which happens a lot, i wanted to create a quick way to generate the c... (115 天前)

http://inezha.com/w/ndsq65xr

Daily Dose of Excel

In a class module, why use an unrestricted property?

over the years, i have followed the “best practice” of always using a property get and let/set combination rather than just declaring a public variable. but, over the last few months i’ve started questioning this dictum.now, before people start jumping up and down, i am aware of the many very, very good reasons why one should use properties rather th... (116 天前)

http://inezha.com/w/9fkbl5xh

Daily Dose of Excel

More Class Module Automation

how was that video? pretty super-awesome, huh?you can download vbhelpers.zipit’s rough, to say the least, but if you want to mess around with it, have at it. here’s some more information on what was happening in that video:0:00 first i insert a class module. inserting modules is one of those activities that bugs me. i do it enough that the extra few... (121 天前)

http://inezha.com/w/b7vh55x9

订阅者 ( 2 )

相关订阅源