Very useful VBA codes

Workbook

1. Save workbook or save workbook in shared mode
2. Open File Dialog Box
3. Number format for Europe
4. Display name turns into an email address
5. Check AutoSave of workbook
6. Get File name from path
7. Reverse String
8. Calculate Total Run Time
9. Paste value as value and formula as formula
10. Filter list with multiple criteria in same column
11. Replace Cell Formula
12. Number to Text
13. Compile Workbooks with Filter
14. Change shape color

Pivot

1. Refresh specific pivot table
2. Add measures into pivot table
3. Filter multiple items in Pivot
4. Add custom sort list and apply on pivot
5. Add fields into pivot table
6. Add or remove pivot calculated field without loop
7. Add or remove pivot calculated field with loop
8. List all the pivot tables in a workbook
9. Change pivot value field based on another cell value

Chart

1. Change Chart Max Axis

BO (Business Object)

1. Check SAP add-in
2. Activate SAP add-in
3. Deactivate SAP add-in
4. Refreshing BO queries for entire workbook
5. Apply background filter in BO

SAP

1. Get ID & Text of each control in SAP window
2. Other very useful codes for SAP
3. Click on Generate/Replace file button
4. By-pass Information windows
5. Get SAP date format
6. Close Excel instances of SAP
7. Close pop up if title is Information
8. Save SAP screenshot to folder

PDF

1. Export as PDF

Web

1. Excel Table to HTML Table
2. Open browser in background
3. Words count on a web page
4. SharePoint File Download
5. Open Share Point Folder
6. Sync Files
7. Close Internet Explorer

Outlook

1. Open message file
2. Save Email Attachments

System

1. 32 to 64 bit conversion

Others

1. Remove lines from VBA procedure
2. Create Windows Task Scheduler entry using VBA
3. VBA Functions
4. Add month to dictionary
5. VBA Free
6. Insert Code/Sub Procedure at runtime
7. Delete VBA Procedure