• Skip to main content
  • Skip to primary sidebar

Ryan McCormick

Dedicated Dad, Software Engineer and Lover of Coffee

Archives for March 2014

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

Calculate Date in Business Days in VBA Without Database Tables

March 25, 2014 by Ryan McCormick 2 Comments

In a recent project, I had to build a program to calculate an end date in either business days or calendar days based on certain criteria. This solution had to work in both Excel and Access and needed to run without the use of database tables. Business Day Calculation Requirements The criteria I used to determine the definition of a business day was any non holiday weekday. … [Read more...] about Calculate Date in Business Days in VBA Without Database Tables

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?

How to Count by Item With SQL | Group By Query MS Access

March 6, 2014 by Ryan McCormick Leave a Comment

I also wasn't sure how to word the title, but it seems to make sense. This is a very short post as this is pretty simple. When reporting out on data, there is the possibility that at some point, a report request will call for a count of items by group. I wanted to make this example as simple as possible. To keep it simple, I designed a table with first names(FirstName) and … [Read more...] about How to Count by Item With SQL | Group By Query MS Access

Crack Microsoft Excel Password Free | Excel 2007, 2010, 2013

March 5, 2014 by Ryan McCormick 29 Comments

It is always annoying when forgetting passwords. It is also annoying when you inherit a document from a previous employee and it is protected by a password only they knew. But your boss asked for you to get the data from that spreadsheet and change some things and Right now! What are you going to do? Well the good news is that if the document isn't encrypted, this process is … [Read more...] about Crack Microsoft Excel Password Free | Excel 2007, 2010, 2013

Next Page »

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