Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi
VBA Code to Convert Excel Range into HTML Table
Excel VBA Codes/Macros

VBA Code to Convert Excel Range into HTML Table

Byexcelsirji

This Excel VBA Code converts the excel range into HTML and also can convert Excel to HTML Table to paste data on Outlook Email Body

Read More VBA Code to Convert Excel Range into HTML TableContinue

Custom Calendar Control for MS Access
Excel VBA Codes/Macros

Custom Calendar Control for MS Access

Byexcelsirji

MS Access by default provides inbuilt functionality to pick dates using calendar control; however it lacks few basic functionalities which makes selecting a date bit difficult. For example, if you want to select a date…

Read More Custom Calendar Control for MS AccessContinue

How to Add Outlook Reference in Excel VBA
Excel VBA Codes/Macros

How to Add Outlook Reference in Excel VBA

ByKailash Sharma

To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in Excel VBA: 1….

Read More How to Add Outlook Reference in Excel VBAContinue

VBA Code to Hide Menu Ribbon in MS Access
Excel VBA Codes/Macros

VBA Code to Hide Menu Ribbon in MS Access

ByKailash Sharma
VBA CODE TO HIDE MENU RIBBON IN MS ACCESS In MS Access, there are multiple ways to protect your code or tool from un-authorized access and edits. Some developers prefers to hide MS Access ribbons...

Read More VBA Code to Hide Menu Ribbon in MS AccessContinue

VBA Code to Export Access Recordset to Excel
Excel VBA Codes/Macros

VBA Code to Export Access Recordset to Excel

ByKailash Sharma

Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle multiple users. Still people prefer to pull and see the…

Read More VBA Code to Export Access Recordset to ExcelContinue

How to Create dropdown List in Excel
Excel Dashboarding Tips | Excel Data Tips

How to Create dropdown List in Excel

Byexcelsirji
Watch Excel Tutorial Video - How To Create Dropdown List In Excel Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is...

Read More How to Create dropdown List in ExcelContinue

Create Dynamic Data Validation List – Offset Function Method
Excel Dashboarding Tips | Excel Data Tips

Create Dynamic Data Validation List – Offset Function Method

Byexcelsirji
Watch Excel Tutorial Video - Create Dynamic Data Validation List – Offset Function Method When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation”...

Read More Create Dynamic Data Validation List – Offset Function MethodContinue

VBA Code to Send Outlook Emails
Excel VBA Codes/Macros

VBA Code to Send Outlook Emails

ByKailash Sharma

Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the…

Read More VBA Code to Send Outlook EmailsContinue

VBA Code to Draft Outlook Emails
Excel VBA Codes/Macros

VBA Code to Draft Outlook Emails

ByKailash Sharma

Have you ever felt the need of an Excel based VBA tool or code which can help you to draft Outlook emails in bulk by reading recipients and other details from Excel? Here is very…

Read More VBA Code to Draft Outlook EmailsContinue

VBA Code to Read Outlook Emails
Excel VBA Codes/Macros

VBA Code to Read Outlook Emails

ByKailash Sharma

Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and time consuming. Here is a VBA…

Read More VBA Code to Read Outlook EmailsContinue

VBA Code to Browse a Folder
Excel VBA Codes/Macros

VBA Code to Browse a Folder

ByKailash Sharma

Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code that can be used to browse…

Read More VBA Code to Browse a FolderContinue

VBA Code to Browse an Outlook Folder
Excel VBA Codes/Macros

VBA Code to Browse an Outlook Folder

ByKailash Sharma

Outlook is most commonly used emailing application used in the world. Many people spend their entire day on Outlook application to read and response to emails. To automate certain rule based tasks in Outlook, we…

Read More VBA Code to Browse an Outlook FolderContinue

VBA Code to Count Color Cells with Conditional Formatting
Excel Formula Tips | Excel VBA Codes/Macros

VBA Code to Count Color Cells with Conditional Formatting

ByKailash Sharma

Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then you can use following code which counts the number…

Read More VBA Code to Count Color Cells with Conditional FormattingContinue

VBA Code to Browse a File
Excel VBA Codes/Macros

VBA Code to Browse a File

ByKailash Sharma

There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a sample code where I have given a browse button…

Read More VBA Code to Browse a FileContinue

How to Count Color Cells in Excel- Step by Step Tutorial
Excel Formula Tips | Excel VBA Codes/Macros

How to Count Color Cells in Excel- Step by Step Tutorial

ByKailash Sharma
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells...

Read More How to Count Color Cells in Excel- Step by Step TutorialContinue

Page navigation

Previous PagePrevious 1 … 5 6 7
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search