
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »