Blogspot - vbadud.blogspot.com - VBA Tips & Tricks
General Information:
Latest News:
Convert PowerPoint TextBox Slides as Notes using VBA 27 May 2013 | 10:46 am
How to Add Notes to Powerpoint Slides using VBA It has been quite some time since I posted in this blog. Murugan had kindled that in the form of the following snippet. We are had earlier tried Creati...
Convert PowerPoint TextBox Slides as Notes using VBA 27 May 2013 | 10:46 am
How to Add Notes to Powerpoint Slides using VBA It has been quite some time since I posted in this blog. Murugan had kindled that in the form of the following snippet. We are had earlier tried Creati...
How to Save PowerPoint Presentation as PDF using VBA 12 May 2012 | 06:44 pm
How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around .. it is better ...
How to Save PowerPoint Presentation as PDF using VBA 12 May 2012 | 02:44 pm
How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around .. it is better ...
Excel VBA TimeStamp – Milliseconds using Excel VBA 7 May 2012 | 02:56 am
How to Get Time in Milliseconds using Excel VBA The following function uses Timer function to get the milliseconds and append it to the current time Public Function TimeInMS() As String TimeInMS = ...
Excel VBA uninstall Excel Addins 7 May 2012 | 02:55 am
Programmatically uninstall Excel Addins using VBA Sub UnInstall_Addins_From_EXcel_AddinsList() Dim oXLAddin As AddIn For Each oXLAddin In Application.AddIns Debug.Print oXLAddin.FullName If oXLAd...
Retrieve / Get First Row of Excel AutoFilter using VBA 7 May 2012 | 02:54 am
Extract First Row of the Filtered Range using Excel VBA We can create filters programmatically using Excel VBA () and also add multiple criteria to it (). Once we get the filtered data, either we ext...
Embed Existing Word File to Spreadsheet using Excel VBA 7 May 2012 | 02:54 am
Insert Existing File (Word Document) to Spreadsheet using VBA Sub Insert_File_To_sheet() Dim oWS As Worksheet ' Worksheet Object Dim oOLEWd As OLEObject ' OLE Word Object Dim oWD As Document ' Wor...
UnInstall Word Addins using VBA 7 May 2012 | 02:53 am
Here is a simple method to uninstall a Word Addin (.dot file) using Word VBA Private Sub UnInstalled_AllWordAddins() Dim oAddin As AddIn On Error GoTo Err_Addin For Each oAddin In AddIns If oAddi...
Word VBA add command buttons through code 7 May 2012 | 02:52 am
Add CommandButton to Word Document using VBA (through AddOLEControl) Here is one of the ways to add a command button on a Word document using Word VBA Sub Macro_Add_Button() Dim oCtl Dim oCmd Set...
