Objective To import or export a VBA code module. Approach Sometimes we want to export […]
Objective To apply and remove the filter on excel range using VBA Excel. Apply Filter […]
Objective To highlight and identify duplicate values in a column using VBA Excel. Approach Here […]
Objective Find position of a string in another string by using Instr function of VBA […]
Objective To import text file data in excel worksheet using VBA Excel. Approach Here we […]
Objective To create a message box with Yes and No option. Approach Here we have […]
Objective To split the data in column using VBA Excel. Approach Here we wanted to […]
Objective To convert multiple xls files to xlsx using VBA Excel. Approach Here we shall […]
Objective To convert multiple word files (.docx) to PDF using VBA Excel. Approach Here we […]
Objective To rename multiple folders using VBA Excel. Approach Here in the code below we […]