Productivity And Automation

VBA Code to Re-link MS Access Link Tables

Byexcelsirji

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location

Productivity and Automation

VBA Code to List Files in Folder

Byexcelsirji

VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. In this article we will learn three…

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.

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…

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.

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…

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

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…

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…

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…

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…

Excel VBA and Macros | Productivity and Automation

VBA Code to Send Outlook Emails

ByKailash Sharma

VBA Code to send Outlook Emails Sending bulk emails is a very common activity, there are many office activities that need a person to send bulk emails to single or multiple recipients. You also may…