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 »
This snippet converts the TextBoxes / Shapes with Text that are available in PowerPoint Slide to Notes Section. Sub Export_TextBoxes_AsNotes() Dim oPPT As Presentation Dim oSlide As Slide Dim oSlideShape… Read more »
A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… 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 »
PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around, it is always better to circulate the Deck… Read more »
For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog. Suppose you have been… Read more »
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… 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 »
Today I am going to discuss simple ways to write the VB programming in the most efficient manner to, optimize the VBA code saving a lot of time for the… Read more »
So you’ve found some VBA code on the internet that will save you hours and hours of work, but how do you get it into Excel and use it? Often… Read more »