Site Map
For a list of all blog posts, see the Table of Contents.
All Articles
- 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
- Comment Shape Formatting
- Create Data Queries
- Custom Lists in Excel
- Daily Time Log Workbook
- Early 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
- List Names in Workbook
- List of Enumerated Constants for Late Bound VBA Automation
- Merge Workbooks
- 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
- 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
- Automate Outlook
- Change any Outlook Item Property from Excel
- Create Followup Task Reminders with VBA
- Delete Expired Items
- Etiquette Check
- Excel Automation
- Going on Vacation with Outlook
- Mailing List Management in Outlook 2003
- Outlook 2003 Object Model breakdown — The NoteItem Object
- Outlook 2003 Object Model breakdown — The TaskItem Object
- Outlook 2003 Object Model breakdown — The AppointmentItem Object
- Outlook 2003 Object Model breakdown — The MailItem Object
- Outlook 2003 Object Model breakdown — The PostItem Object
- 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?
- Abbreviations.com API Code Samples
- Add Fax functionality to your VBA programs
- Business.gov Web API – Financing
- Create new text documents using VBA
- Echo Function
- Grab Registry Settings through VBA using WMI
- NYS Legislature API Examples
- Send SMS messages via XMLHTTP and VBA
- Shell Scripting using VBA and the Windows Script Host Object Model
- 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
- Visual Basic Keywords
- Working with the Wordnik API in VBA
- Working with Windows APIs in VBA
- World Bank API
Most Commented Articles
Browse Blog Posts by Month
Most Viewed Pages
Articles By Author
Categories
- Office Cafe (6)
Most Viewed Articles In Each Category
Category: .NET
Popular Tags
Access add add-in addin AddressList API Application appointment AppointmentItem archive array ATPVBAEN attachment attachments autofilter Automation backup best practice bingo number generator BuiltIn chart CommandBar conditional formatting conference contacts contest control convert CreateItem CreateObject Data Filter Tool data validation database dir DistListItem distribution list download event event handler Excel export extract feed find GetNS GetOutlookApp hyperlink IE IF INDEX Internet Explorer InternetExplorer ItemAdd ItemSend Len Links MailItem match MID MSXML MSXML2 name names networkdays object library Office Outlook parent PivotTable print privacy property query random range Rant Recipients Remove replace Row Sarbanes Oxley SaveAsFile shipment tracking ShipTrack signature sort split stats string SUMPRODUCT table text file time difference training truth table Tutorial update userform validation VBA Visible vlookup weather WithEvents workbook working hours worksheet XML XMLHTTP zip
