This site under reconstruction.
Today we found somebody fudging the numbers.Normally it’s hard to catch on to tricks but today my boss wanted to look at some trends for 2016 and she saw some stuff that looked weird. She asked me to investigate. She was wondering why a certain metric kept coming up as the same number for a…
Creating macros to move or copy files from one folder to another should be easy but it turned out to be problematic.I’m working on a new project called the Paperless Office project (I named it that). I’ve been doing a lot of research and some of that research is trying to see if I could…
Sometimes, people just want to do things manually.There is a weekly report that I created almost 2 years ago that pulled in data via macro. It basically does the job for you in 5 minutes and all you have to do is review the numbers. Now. sometimes you have to fix some errors but those errors are…
This post will be short because I spent the weekend on developing some artwork (and one failed) and it is now getting late. I do want to post a macro that I found in Stack Overview (I thought I copied the link) and fixed to work on my PC, altering it a little to fix…
It seems to me that every Monday now, my macro no longer works in the office. Outside of the office, such as my home or the hotel, the program works. This past Monday, it started out with my inability to access the internet. My machine just would not go to our vendor’s site that we…
My usual macro that I use to collect Excel files into a summary report failed me on Monday. But someone else could use the macro which told me that the problem was with my machine, not the macro.This post will be short since it is late but I do want to point out some steps…