You are here: Home » Archives for Rant
Rant icon

Excel VBA Performance in Office 2007

calendar date March 13, 2009 by comment bubble 10 Comment(s)

I was just reading the MSDN Excel blog, which published a new post about VBA performance. It's called Excel VBA Performance Coding Best Practices and was published as a followup to a previous post on the same blog soliciting feedback from Excel users on performance issues in Excel 2007 VBA.

Continue Reading: Excel VBA Performance in Office 2007 »

categories Filed Under: Rant tags Tagged With:
Excel iconOutlook iconRant icon

The Wrong Way to Declare Application Objects

calendar date December 9, 2008 by comment bubble 2 Comment(s)

In Outlook programming : Looping individual mails inside the Inbox, blogger Deva Gnanam .J shows some sample code for looping through the default Inbox and performing some action on the emails in that folder.

Continue Reading: The Wrong Way to Declare Application Objects »

categories Filed Under: Excel, Outlook, Rant tags Tagged With: ,
Rant iconVBA icon

VBA Rant #1

calendar date May 8, 2008 by comment bubble 3 Comment(s)

I'm sure by now you are aware that Microsoft has been distancing itself from VBA.

As of July 1, 2007, they are no longer licensing VBA (to new clients). For example, if you wrote a program today and wanted to integrate VBA in it, you are out of luck.

Continue Reading: VBA Rant #1 »

categories Filed Under: Rant, VBA tags Tagged With: ,
Random Data Generator