• Skip to main content
  • Skip to primary sidebar

Ryan McCormick

Dedicated Dad, Software Engineer and Lover of Coffee

Excel

Download Outlook Calendar VBA Example

September 10, 2014 by Ryan McCormick 7 Comments

Wow time is flying! Looks like my last post was in June! I built this example due to frustration. I was trying to find a way to look at and manipulate appointments in my Outlook calendar for a three month time span. The tool that I built, ultimately loaded the pulled outlook calendar items into a table. I decided not to include that part in this article as it is pretty … [Read more...] about Download Outlook Calendar VBA Example

How to Find Fourth Thursday of November in VBA

June 18, 2014 by Ryan McCormick 2 Comments

I recently built a project where I had to count business days by excluding weekends and US Federal holidays. In my previous post: , my example used hard-coded dates. This new example can be adapted and re-coded to find the date of any specific weekday or holiday of the year without the need to hard-code. Public Function dThanksgiving(curDate As Date) As Date 'Define … [Read more...] about How to Find Fourth Thursday of November in VBA

Simple Mortgage Calculator Function | Excel, Access VBA

May 22, 2014 by Ryan McCormick 1 Comment

There are a lot of ways to calculate a mortgage payment in Excel. I honestly haven’t made any attempts to calculate a mortgage payment in Access using standard functions. There has to be a way, but for fun, I thought that I would share a simple function. To use this function, insert it into a module. For Excel, make sure you save your Excel document as a "Macro-Enabled" … [Read more...] about Simple Mortgage Calculator Function | Excel, Access VBA

Set Appointment in Outlook With VBA in Access or Excel 2010, 2013

March 26, 2014 by Ryan McCormick 6 Comments

When writing automation for certain processes, it is sometimes important to set a follow-up reminder appointment for the next step. For this task, I wrote a very simple script that sets a reminder in Outlook. This script is super simple and can be improved several different ways. For simplicity sake, I decided to leave out the fancy "With" procedure and just use the object … [Read more...] about Set Appointment in Outlook With VBA in Access or Excel 2010, 2013

Why Don’t My Columns Add in Excel?

March 10, 2014 by Ryan McCormick Leave a Comment

There are many ways an end user can run into this problem. One of the most common causes that I have seen is when pasting data. Enter the Datatype Sometimes when data is pasted, no matter if it is in a number format from the original source - it can be pasted as text or in string format. Strings are great, they can help display data in a wide variety ways, including numbers … [Read more...] about Why Don’t My Columns Add in Excel?

Primary Sidebar

Recent Posts

  • Force Quit Kill all Chrome Windows MacOS
  • SOLVED: Angular 6 CLI Karma Stuck in Single Run | Karma Stops Running
  • How to Manually Install Java 8 on Ubuntu 18.04 LTS
  • Remove VirtualBox from Ubuntu 16.04 Xenial
  • Clear all Node Modules Folders Recursively Mac/Linux

Recent Comments

  • KKV on Webstorm adding spaces between imports and braces | JavaScript and TypeScript
  • jusopi on Clear all Node Modules Folders Recursively Mac/Linux
  • Qaisar Irfan on Clear all Node Modules Folders Recursively Mac/Linux
  • mustafa on Remove VirtualBox from Ubuntu 16.04 Xenial
  • Pourya on How to Manually Install Java 8 on Ubuntu 18.04 LTS

Archives

  • May 2019
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • March 2017
  • December 2015
  • November 2015
  • July 2015
  • April 2015
  • February 2015
  • September 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • October 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • December 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • May 2012
  • March 2012
  • February 2012
  • December 2011
  • November 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • August 2009
  • July 2009
  • May 2009

Categories

  • Angular
  • Angular 2
  • AngularJS (1x branch)
  • Computer Q&A
  • ES2015
  • Internet Marketing
  • Javascript
  • Job Interviews
  • Job Search
  • Karma
  • Laravel
  • Linux
  • Linux/Unix Tips
  • MacOS
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Word
  • News
  • Node
  • Open Source
  • PHP
  • Protractor
  • Resume Writing
  • Spring Boot
  • SQL
  • Ubuntu
  • VBA
  • VBScript
  • VirtualBox
  • Web Development
  • Windows Tips
  • Wordpress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in