vba code – Anil Nahar

Download Excel 2016 VBA Code: Just Copy – Paste – Run (For Accountant) Part -2

Excel having large collection of functions in-built . Mostly those functions are sufficient to complete the work. Sometimes, Excel doesn’t have a pre-built function that suits a specific need, Well not to worry about it , you can create your…

March 1, 2019 · by Anil Nahar · 0

Insert Multiple Text file in Worksheet ready vba code

Sub MulipleTextFiles() ‘SmartCode for Insert Multiple text file in worksheets ‘SmartExcel(www.anilnahar.com) Dim xFilesToOpen As Variant Dim I As Integer Dim xWb As Workbook Dim xTempWb As Workbook Dim xDelimiter As String Dim xScreen As Boolean On Error GoTo ErrHandler xScreen…

June 9, 2018 · by Anil Nahar · 0