Workbook
- Save workbook or save workbook in shared mode
- Open File Dialog Box
- Number format for Europe
- Display name turns into an email address
- Check AutoSave of workbook
- Get File name from path
- Reverse String
- Calculate Total Run Time
- Paste value as value and formula as formula
- Filter list with multiple criteria in same column
- Replace Cell Formula
- Number to Text
- Compile Workbooks with Filter
- Change shape color
- Print All queries/connections
- Refresh Query
- Display Active Workbook Path
- Refresh All Data Connections
- Save Excel Backup Automatically
Pivot
- Refresh specific pivot table
- Add measures into pivot table
- Filter multiple items in Pivot
- Add custom sort list and apply on pivot
- Add fields into pivot table
- Add or remove pivot calculated field without loop
- Add or remove pivot calculated field with loop
- List all the pivot tables in a workbook
- Change pivot value field based on another cell value
- Remove filters from Pivot and range together
Chart
- Change Chart Max Axis
- Create a Chart from Data
- Change Chart Type
- Add Chart Title
- Add Axis Titles
- Change Chart Colors
- Add Data Labels
- Create a Pie Chart
- Move Chart to New Sheet
- Update Chart Data Dynamically
- Loop All Charts and Refresh
- Add a Secondary Axis
- Export Chart as an Image
- Resize and Move Chart
- Change Chart Style
- Add Trendline
- Add Chart Legend
- Create a Line Chart
- Delete All Charts
- Copy Chart to Another Sheet
- Automatically Create Charts for Each Column
BO (Business Object)
SAP
- Get ID & Text of each control in SAP window
- Other very useful codes for SAP
- Click on Generate/Replace file button
- By-pass Information windows
- Get SAP date format
- Close Excel instances of SAP
- Close pop up if title is Information
- Save SAP screenshot to folder
- Export as PDF
- Export Excel Sheet to PDF
- Save Specific Range as PDF
- Export Multiple Sheets as One PDF
- Convert Word Document to PDF (From Word)
- Attach Generated PDF to Outlook Email
- Print PDF Automatically (Using Shell)
PowerPoint
Web
- Excel Table to HTML Table
- Open browser in background
- Words count on a web page
- SharePoint File Download
- Open Share Point Folder
- Sync Files
- Close Internet Explorer
- Open Edge browser with predefined url
- Open SharePoint using Shell
Outlook
- Open message file
- Save Email Attachments
- Send Mail Notification
- Send an Email from Excel/Word/PowerPoint
Word
- Add Text to the Document
- Create a New Document and Add Text
- Save Document Automatically
- Find and Replace Text
- Apply Bold & Font Size
- Add Page Numbers
- Insert Header & Footer
- Insert Table
- Protect Document (Password)
- Loop Through Document Paragraphs
- Show MsgBox with Document Word Count
- Convert Word to PDF
- Export Current Document as PDF
- Close Document Without Save Prompt
- Remove Extra Spaces from Entire Document
- Convert All Text to Uppercase
- Highlight All Occurrences of a Word
- Autofit Table to Window
- Add Colored Row to Table
- Apply Title Style to First Paragraph
- Insert Page Break Every 2 Paragraphs
- Add Bookmark to Selected Text
- Jump to a Bookmark
- Run Mail Merge to New Document
- Insert Image into Word
- Create Table of Contents Automatically
System
- 32 to 64 bit conversion
- Get System User Details
- System Date & Time
- Check If Folder Exists
- Create Folder Programmatically
- Open Any Website From VBA
- Detect Office Version Installed
- Run External EXE from VBA
- Get Screen Resolution
- Check If User Is Admin (Windows Group)
- Play Windows Beep Sound
- SystemInfo Command Dump
- System Monitor Trick
Others
- Remove lines from VBA procedure
- Create Windows Task Scheduler entry using VBA
- VBA Functions
- Get user ID
- Get user Name
- Get Outlook properties like mobile number, email etc.
- Add month to dictionary
- VBA Free
- Insert Code/Sub Procedure at runtime
- Delete VBA Procedure
Tags
VBA