How to Repair Excel Workbook using VBA?
The following code uses VBA to open and repair the workbook (the option available using Excel Open Dialog) Sub OpenAndRepairWorkbook() Dim oWB As Workbook On Error GoTo Err_Open Set oWB… Read more »
Tag Archives: Macro
How to extract Excel File properties without opening a File using VBA?
There are many cases where we need to get the document property without the file being opened in VBA. This can be achieved by using the objects available in DSOFile.dll…. Read more »
VBA Code Bank – Open Powerpoint in Excel using VBA
Microsoft Excel and Powerpoint are perfect partners for Dynamic Tables and Dashboards. PowerPoint 2010 and PowerPoint 2013 introduced improvements to a lot of features, but sadly PowerPoint Tables was not… Read more »
VBA Code – To split an Excel PIVOT Table into Multiple Reports
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the… Read more »
How to copy set of files from one folder to another using VBA?
Here is a simple code that moves all the files from one folder to another using XCOPY. You can use all the options of XCOPY with VBA Sub Copy_Bunch_Of_Files() Shell… Read more »
What is so good about VBA?
Here is why I think VBA is so great, but first let’s try and define VBA. A tightly integrated application automation system that allows professionals from non software development disciplines… Read more »
How to Compare Word Documents using Word VBA?
Word Documents are everywhere – proposals, tenders, notes, technical papers. In many cases there are more than one authors and more than five reviewers. Just in case you get a… Read more »
Create a sheet multiple times and rename it to a given name using VBA
You may have template sheet which you need to copy multiple times and rename these sheets according to the list (maybe on another sheet). Suppose you have a sheet named… Read more »
How to get the free space available using VBA?
The FreeDiskSpace property can be used to retrieve the free space information from Word VBA Sub FreeDiskSpace_Current_Drive() Dim sFreeSpace As String sFreeSpace = System.FreeDiskSpace sFreeSpace = Format(sFreeSpace, “0,000”) MsgBox “Free… Read more »
How to Connect SQL Express 2005 from VBA?
Here is a way to connect to SQL Express 2005 from Excel VBA Sub Connect2SQLXpress() Dim oCon As ADODB.Connection Dim oRS As ADODB.Recordset Set oCon = New ADODB.Connection oCon.ConnectionString =… Read more »