Skip to content
Learn Excel
  • Free TutorialsExpand
    • Excel Basics
    • Excel Functions
    • Advanced Excel Techniques
    • Data Analysis
    • Data Visualization
    • Productivity and Automation
    • Excel VBA and Macros
  • Courses
  • Consulting
  • LOG-IN
Join Free Excel Training
Learn Excel
  • VBA Code to Check if File Exist in Folder
    Productivity and Automation

    VBA Code to Check if File Exist in Folder

    Byexcelsirji

    To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

    Read More VBA Code to Check if File Exist in FolderContinue

  • VBA Code to Add New Sheet at Beginning or End of Excel File
    Excel VBA and Macros | Productivity and Automation

    VBA Code to Add New Sheet at Beginning or End of Excel File

    Byexcelsirji

    VBA Code To Add New Sheet In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet…

    Read More VBA Code to Add New Sheet at Beginning or End of Excel FileContinue

  • VBA Code to Get User Name
    Productivity and Automation | Excel VBA and Macros

    VBA Code to Get User Name

    Byexcelsirji

    This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

    Read More VBA Code to Get User NameContinue

  • excel tutorial online
    Excel VBA and Macros | Productivity and Automation

    VBA Code to Delete All Shapes On A Excel Sheet

    Byexcelsirji

    VBA Code To Delete All Shapes On A Excel sheet Here is a VBA code which deletes all the shapes from an Excel sheet. Code is simple but you have to be bit careful while…

    Read More VBA Code to Delete All Shapes On A Excel SheetContinue

  • excel spreadsheet tutorial
    Excel VBA and Macros | Productivity and Automation

    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

  • learn excel formulas
    Excel VBA and Macros | Productivity and Automation

    Custom Calendar Control for MS Access

    Byexcelsirji

    Custom Calendar Control for MS Access 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…

    Read More Custom Calendar Control for MS AccessContinue

  • learn ms excel
    Excel VBA and Macros | Productivity and Automation

    How to Add Outlook Reference in Excel VBA

    ByKailash Sharma

    How to Add Outlook Reference in Excel VBA? 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…

    Read More How to Add Outlook Reference in Excel VBAContinue

  • learn excel macros
    Excel VBA and Macros | Productivity and Automation

    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

  • learn advanced excel
    Productivity and Automation | Excel VBA and Macros

    VBA Code to Export Access Recordset to Excel

    ByKailash Sharma

    How to Export Access Data to Excel using VBA Code? 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…

    Read More VBA Code to Export Access Recordset to ExcelContinue

  • excel tutorial formulas
    Excel Basics

    How to Create dropdown List in Excel

    Byexcelsirji

    Watch Excel Tutorial Video – How To Create Dropdown List In Excel How to Create a Dropdown list in excel?  Microsoft Excel is what most professionals are using for their day-to-day office.  Creating a drop-down…

    Read More How to Create dropdown List in ExcelContinue

Page navigation

Previous PagePrevious 1 … 22 23 24 25 Next PageNext
DMCA.com Protection Status
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2026 Learn Excel

Scroll to top
  • Free Tutorials
    • Excel Basics
    • Excel Functions
    • Advanced Excel Techniques
    • Data Analysis
    • Data Visualization
    • Productivity and Automation
    • Excel VBA and Macros
  • Courses
  • Consulting
  • LOG-IN
Search