Microsoft Excel Blog
MENU
Skip to content

Please enter your Email-id

@
Subscribe Cancel

Two cents’ worth to get your VBA code to run faster

Today I am going to discuss simple ways to write the VB programming in the most efficient manner to, optimize the VBA code saving a lot of time for the… Read more »

VBA Code Bank, VBA Macro Programming   

How To Use VBA Code From The Internet

So you’ve found some VBA code on the internet that will save you hours and hours of work, but how do you get it into Excel and use it? Often… Read more »

VBA Macro Programming   

How to Link Cells to Files/Folders using Excel VBA?

There are many cases where we want to have a Hyperlink on a cell that opens a document / image etc. In the following snippet we can see how that… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA, Macros, VB Programming

VBA Code to Interact with MS Word

Recently, I had the task of writing a program to populate an SLA (Service Level Agreement) Report. The SLA Report was a Word document with many tables of data and… Read more »

VBA Code Bank, VBA Macro Programming   

Calculate the number of working days between two dates

As an Excel or data analyst, dates in datasets are common and usually involve some work to take from raw data stage into meaningful reports. Employee datasets, sales datasets and… Read more »

Microsoft Excel   

How to copy set of files from one folder to another using VBA?

Here is a simple code that moves all the files from one folder to another using XCOPY. You can use all the options of XCOPY with VBA Sub Copy_Bunch_Of_Files() Shell… Read more »

VBA Code Bank, VBA Macro Programming    Excel VBA, Macro, VB Programming

How to convert a date into a month name?

Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »

Microsoft Excel    Microsoft Excel, Text Functions, Time Saving Techniques

Trick to Complex Excel Formulas

There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »

Microsoft Excel    Excel Formulae, Microsoft Excel

How to protect your VBA Code / Project from an Unauthorized access?

Protecting your VBA scripts may seem a little extreme, especially with so many IT experts now recognising the value of open source and free access but it does have a… Read more »

VBA Code Bank, VBA Macro Programming   

Which chart or graph is a good fit for you?

Choosing the right type of chart or graph visualization can be key to conveying the most important insights in your data on sight. This article will help you determine which… Read more »

Charts ; Graphs    Bar Chart, bubble chart, Charts, Excel, gantt chart, Line Chart, Map, Pie Chart, Scatter plot

Post navigation

← Older posts
Newer posts →
18 - Jan - 2022 Excel VBA Macro Course

Recent Posts

  • Is Power Bi, the silent death of SSRS?
  • Is knowing Excel VBA a good starting point for learning any other programming languages?
  • How to Show Progress on Status Bar using VBA?
  • Open XML File in Excel
  • Why Vlookup when there is Index?

Archives

  • September 2021
  • August 2021
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • April 2015
  • March 2015
  • February 2015
  • November 2014
  • October 2014
  • July 2014
  • April 2014
  • March 2014

Categories

  • Charts ; Graphs (4)
  • Dashboards (2)
  • Microsoft Excel (29)
  • Power BI (1)
  • PowerPivots (4)
  • Uncategorized (1)
  • VBA Code Bank (32)
  • VBA Macro Programming (34)

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Copyright 2016
Excelgoodies, Inc.
Ribosome by GalussoThemes.com
Powered by WordPress