Very Useful VBA codes

Workbook

1. Save workbook or save workbook in shared mode
2. Open File Dialog Box
3. Number format for Europe

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

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

PDF

1. Export as PDF

Web

1. Excel Table to HTML Table
2. Open browser in background
3. Words count on a web page

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