I was watching a favorite YouTube channel and the Jack-of-all-trades Host said, “I find do my best work when I am organized”. For most of us not only do you do your best work but I will wager you are more productive, experience less frustrations and walk away from the task happier. I know I […]
Floating Page Numbers
The VBA MS Office Developers Journal The VBA MS Office Developers Journal The Client request: “Do you know much about inserting page numbers into Word docs? I have had a few requests for it; if it is easy enough I might do it. I tried the Page number but it messes up my formatting. Since […]
Excel Web Scraping Custom Function Builder
The clients request was simple I want to pull the following financial statistics from the Wall Street Journal and Market Watch:1) Name form Ticker Symbol2) Total Revenues3) Non Operating Interest Income4) Total liabilities He was nice enough to provided the URLS as follows: The Wall street Journalhttps://www.wsj.com/market-data/quotes/AAPL/financials/annual/balance-sheet Market Watchhttps://www.marketwatch.com/investing/stock/AAPL/financials/balance-sheet/quarter” I did the job and built […]
Custom Excel Worksheet Protection
The scene was repeated far too many times: We sent out our Excel forecast single worksheet workbooks to the various divisions with specific instructions: Do not change anything, do not add rows or columns. Just input your forecast. Simple right? Invariably about 10PM when we ran our consolidation it failed. https://youtu.be/nC3a-1ROW3U Why? because a division […]
Excel Audit Trail
The client called with a query: “I am trying to figure how I can make the attached spreadsheet highlight with yellow fill any change made by the user after the sheet is refreshed. The idea is the user would refresh the data from our database and if they wanted to make a change they would make […]
Excel Status Forms – Keep your User informed
You have just spent the last three days perfecting a killer dashboard for Maximum Trucking Inc. It reaches out to 8 different site data sources. The graphics are spot on and identify trends and emerging issues. You run it again to test the final version and realize it takes over two Minutes to run. No, […]
MS Office Developer 18 months in
It has been a year and half since I left the corporate world and hung up my virtual shingle. Well, that is when I published my Microsoft Office Development www.excelandvbacraftsman.com website that is. My side-hustle goals were simple: Generate a modest amount of income while not working full time. Hard work, a lifetime of saving, […]
10 Steps to Build Your Freedom Nest Egg
As a financial guy I believe overspending and insufficient savings are the cause of too much unneccessary pain. I have decided to deviate from my normal Excel Posts for what I believe can be a life changing discpline to adopt. I call it 10 Steps to Build Your Freedom Nest Egg. it is a post […]
Simple Smart Document Tool
I have been applying for Freelance VBA jobs on several of the big Job Boards for some time now. It is a highly competitive marketplace where your bid (response) document must be concise, precise and convince the poster that you have the skills necessary to get the job done. Think of my bid as a […]
Efficiency Audit
Smart Document Tool When the famous bank robber Willie Sutton was asked why he robbed banks? his classic response was “because that’s where the money is (1)” The quote evolved into Sutton’s law which is often invoked to medical students as a metaphor for emphasizing the most likely diagnosis, rather than wasting time and money […]