Site Map

Pages:

Contribute
Credits
Downloads
FAQ
Home
Legal
Payment Complete
Spread the word
Visitor Survey
Add-Ins
Excel VBA
- Acronyms in Excel
- Airport Information using XMLHTTP
- Application-level Properties
- Automate Internet Explorer
- Automated Word Mail Merge From Excel
- Baby Activity Tracker Worksheet
- Buzzword Bingo
- Calculation Mode and Excel Optimization
- Case Changing in Excel
- Charting Add-Ins by Peltier Technical Services
- Check If Office App Is Running
- Coffee Club Sign-In Sheet
- Comment Shape Formatting
- Create Data Queries
- Custom Lists in Excel
- Daily Time Log Workbook
- Early and Late Binding
- Excel Add-In (XLA) Best Practices and Design Techniques
- Excel Dashboards
- Excel's Character Set Workbook
- Face ID Toolbar Generator
- Fix State Names
- Formatting SSN
- Freeze Excel Panes with VBA
- How To: Return a list of filenames using GetOpenFilename
- Latitude Longitude Functions
  - Driving Distance
  - GeoIP API returns latitude and longitude based on IP
  - Get Latitude and Longitude from Fly On Time API
  - Great Circle Distance
  - Zip Codes
- List Names in Workbook
- List of Enumerated Constants for Late Bound VBA Automation
- Merge Workbooks
- NFL Team Feeds and News Spreadsheet
- Password Strength Checker
- Periodic Table of Elements fetching with XMLHTTP
- Process all Files in a Folder
- Rows To Repeat At Top
- Sample Outlook Automation
- Search Engine Browsing
- Send Email from Excel
- Send worksheets by email as separate workbooks
- Soccer news from Sky Sports
- Sort Excel 2003 Ranges By Color
- The Bible In Excel
- Validate Filenames
- varType Function
- Workbook and Worksheet Templates
- Write values to a header row
- Video Tutorials
For Hire
Outlook VBA
- Add From and BCC Fields to Messages
- Automate Outlook
- Change any Outlook Item Property from Excel
- Create Followup Task Reminders with VBA
- Delete Expired Items
- Etiquette Check
- Event Planner and RSVP Manager
- Excel Automation
- Export From Outlook
  - Export Outlook Appointments to Excel
  - Export Outlook Contacts to Excel
  - Export Outlook Emails to Excel
  - Export Outlook Notes to Excel
  - Export Outlook Tasks to Excel
- Get Items Collection from default Outlook folders
- Going on Vacation with Outlook
- Mailing List Management in Outlook 2003
- My Outlook code won't run
- Outlook 2003 Object Model breakdown — The NoteItem Object
  - NoteItem Methods
  - NoteItem Properties
- Outlook 2003 Object Model breakdown — The TaskItem Object
  - TaskItem Events
  - TaskItem Methods
  - TaskItem Properties
  - TaskItem Workflow
- Outlook 2003 Object Model breakdown — The AppointmentItem Object
  - AppointmentItem Events
  - AppointmentItem Methods
  - AppointmentItem Properties
- Outlook 2003 Object Model breakdown — The MailItem Object
  - MailItem Events
  - MailItem Methods
  - MailItem Properties
- Outlook 2003 Object Model breakdown — The PostItem Object
  - PostItem Events
  - PostItem Methods
  - PostItem Properties
- Outlook File Request System
- Redirect Messages
- Remember your Outlook settings
- Reminder Event Handling
- Resend This Message
- Stock Event Code
- Utility Functions for use with Outlook 2003 VBA
- Where do I put my Outlook VBA code?
VBA
- Abbreviations.com API Code Samples
- Add Fax functionality to your VBA programs
- Convert a String to an Array
- Create new text documents using VBA
- Default Values for Variables
- Echo Function
- FCC Census Block API
- FCC Consumer Broadband API
- Filename Parsing Methods
- FileSystemObject VBA Examples
- Get Environment Variable Values
- Grab Registry Settings through VBA using WMI
- Joliprint.com API
- MSXML Object Library Routines
- NASA Image of the Day
- NYS Legislature API Examples
- RANDOM.ORG API
- Read Custom Registry Values in VBA
- Regular Expressions Testing in VBA
- Remove Spaces from Strings in VBA
- SBA.gov Web API Methods – Geodata
- SBA.gov Web API – Financing
- SBA.gov Web Service API Methods – Licenses
- SBA.gov Web Service API Methods – Recommended Sites
- Send SMS messages via XMLHTTP and VBA
- Shell Scripting using VBA and the Windows Script Host Object Model
- To.ly URL Shortening API
- Using WMI Services in VBA
  - Account information using WMI
  - Check file properties using WMI
  - Computer System Information using WMI
  - Desktop information using WMI in VBA
  - Environment information using WMI classes
  - Iterate through mapped drives using WMI
  - Use WMI to check local time zone
  - Use WMI to get drive information from local, network and mapped drives
  - Use WMI to view Operating System Details
  - User Account Information using WMI
  - WMI Accounts and Computer Information
  - WMI Logical Disk Information
  - WMI Time Zone Information
- Validate URLs using HTTP Response Code
- Validating IP Addresses in VBA
- Visual Basic Keywords
- Working with the Wordnik API in VBA
- Working with Windows APIs in VBA
- World Bank API
VBA Search Engine
Contact
About
Shop
Blog
- Comment Policy
- Subscribe
Site Map

Categories:

Authors:

JP (499)

Monthly:

Recent Posts:

Popular Tags:

Access add add-in addin API array attachment attachments autofilter Automation best practice comparison test contacts contest CreateItem CreateObject database DistListItem Excel export extract forward GetDefaultFolder GetObject hyperlink import ItemAdd Len Links MSXML MSXML2 Outlook QuickSteps Reply Restrict ShipTrack stats table toolbar training trim userform VBA vlookup XMLHTTP

Site last updated: May 11, 2013

Random Data Generator