Resize and Relocate Chart
Charts and Visualization VBA

Resize and Relocate the Chart using Excel Range

In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You just need to select the range and your selected chart will be relocated and resized according to selected range. You can move the chart to another worksheet also. Below is the VBA Code- Sub Resize_Chart() Dim cht As Chart On
Input box
VBA

VBA.Inputbox Vs Application.Inputbox in Excel VBA

In this article you will learn the use of VBA.Inputbox and Application.Inputbox in VBA. Input box is used to take the input from use on run time. VBA.Inputbox: To take the input form user we use the Inputbox or VBA.Inputbox. This input box looks like below image – [caption id="attachment_10540" align="aligncenter" width="373"] VBA.Inputbox[/caption]   Below is the Code for VBA.Inputbox- Sub VBA_Inputbox() Dim myinput As Variant myinput = VBA.InputBox("Input the
Create Multiple Folder
VBA

Create Multiple Folders from Excel Range

In the previous article you have learnt how to check the whether a folder exist or not. In this article you will learn we can create multiple folders on one click using excel range.   Below the VBA code to create multiple folder from excel sheet Option Explicit Sub Create_Multiple_Folder() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Sheet1") Dim sub_folder_path As String Dim i As Integer For i = 4
Folder Existence Function
VBA

Check Folder Existence using VBA

During the automating some task in VBA, many times we need to check that a folder is exits or not. For example if you want to create or delete a folder using VBA then you should check first whether that folder exits for not. If that folder exits then you take your next action. It method can prevent you from an error. In this article you will learn how to
Rename the Multiple files
VBA

Rename Multiple File on one click

In this article you will learn how to rename the multiple files available in a folder. In the previous post I have explained you how we can get the files information in a excel sheet. We will use the same method to get the current file names of given folder. Once we have the file names in the excel sheet then we will give new name in another excel column
Get File Information
VBA

File System Object: Get Files information in Excel

In this article you will learn how to get the files information from a folder like File Name, File Type, File size, Last modify date etc. in excel sheet. We will use the file system object to create this. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime
Word to PDF Converter
Templates VBA

Automation: Word to PDF Converter

In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor >
Excel to PDF Converter
Templates VBA

Automation: Excel to PDF Converter

In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime [caption id="attachment_7149" align="aligncenter" width="459"] Add Reference[/caption] We
Dynamic Chart on User Form
Charts and Visualization VBA

VBA: Dynamic Chart on User Form

Creating the Chart on a VBA user form is quite interesting. We have created 4 KPI Charts – Battery Chart, Speedometer Chart, Moving Man Chart and Progress Circle Chart on a User form which is fully dynamic. KPI value is connected with a Textbox. As soon as the text box value will be changed chart will show the updated number. We have also given the Change chart type drop-down. KPI