Add To Outlook Calendar UDF

Wednesday, September 10th, 2008 248 views

    Here is a simple UDF that adds an appointment to your Outlook calendar. It can be used from Excel or VBA, and it should be usable from Access as well (untested). It uses another concept I've also been trying out: checking functions to make sure they are successful by using ...

Posted in Access, Excel, Outlook, UDF, VBA, automation | No Comments »

Calculate Working Days Minus Holidays in VBA

Tuesday, June 17th, 2008 2,269 views

I was looking for a function that calculates working days, minus holidays, for a small project I've been working on. I decided to write one myself, but below I've also demonstrated an alternate way that uses the ATP (Analysis ToolPak) functions for VBA.   [vba] Function WorkDays(StartDate As Variant, EndDate As Variant) ...

Posted in Excel, UDF, VBA | 3 Comments »

Updated blog and new pages

Tuesday, April 8th, 2008 6 views

As you may have noticed, I decided to update the blog, because it was getting hard to navigate. The color scheme was just bringing me down, so I spent about 4-5 hours changing it. That might seem like a lot of time, but I'm a perfectionist so once I start ...

Posted in Excel, UDF, VBA, administrative | No Comments »

UDF to return page headers/footers text

Monday, April 7th, 2008 180 views

Here's a series of short UDFs that will return the page headers and footers for the active worksheet. [vba] Function GetLeftHeader() GetLeftHeader = ActiveSheet.PageSetup.LeftHeader End Function [/vba] [vba] Function GetCenterHeader() GetCenterHeader = ActiveSheet.PageSetup.CenterHeader End Function [/vba] [vba] Function GetRightHeader() GetRightHeader = ActiveSheet.PageSetup.RightHeader End Function [/vba] [vba] Function GetLeftFooter() GetLeftFooter = ActiveSheet.PageSetup.LeftFooter End Function [/vba] [vba] Function GetCenterFooter() GetCenterFooter = ActiveSheet.PageSetup.CenterFooter End Function [/vba] [vba] Function GetRightFooter() ...

Posted in Excel, UDF, VBA | No Comments »