Customize the Task Pane
February 8, 2010 @ 7:30 AM by JP • 22 views • No Comments »
Using the NewFile Object in VBA we can customize the Task Pane in Excel, Access, FrontPage, PowerPoint and Word 2003 to add your file templates and frequently used files to this handy workspace. Use this as part of an add-in install, to add your custom workbooks to the task pane so they can be opened by your users anytime!
Using Outlook's ItemSend Event to BCC Emails
February 5, 2010 @ 7:00 AM by JP • 16 views • 2 Comments »
Browsing Google Blogs for VBA blog posts is an excellent use of your time. This time, I found a blog post on Windows Live by Michael Lu called Outlook Auto BCC VBA. He posted code that uses the ItemSend event to automatically add (and resolve) a BCC Recipient to outgoing emails.
I won't repost his code here; visit his post for that. What I will do is repost my comments, and add some more.
ShipTrack 4.1.2 update available
February 4, 2010 @ 4:30 PM by JP • 35 views • No Comments »
An update to ShipTrack is now available. This update fixes the FedEx issue some users reported (and I assume all were experiencing). Please download and let me know how it works.
Code Locked Versions:
ShipTrack Add-In – Excel 2000-2003 version
ShipTrack Add-In – Excel 2007 version
Code UN-Locked Versions:
ShipTrack Add-In – Excel 2000-2003 version
ShipTrack Add-In – Excel 2007 version
Return Command bar info in a VBA function
February 3, 2010 @ 7:30 AM by JP • 36 views • 2 Comments »
In the previous post I showed a simple sub for listing most of the CommandBar properties. But we can also return this information using a function.
You might do this (in Excel versions prior to 2007) when working with a command bar and need to view its properties before making a change. Here is a function that returns a string array of properties for each Command Bar Object.
Continue reading this entry »
List all Command Bar Properties in Excel
February 1, 2010 @ 7:30 AM by JP • 57 views • No Comments »
If you work with Command Bars in Excel, or write add-ins for Excel 2003 that add custom menu options, you'll need to know various properties such as their names. We'll explore that in this post.
Continue reading this entry »
Reuse text blurbs in Outlook
January 29, 2010 @ 7:00 AM by JP • 46 views • 1 Comment »
A couple of times I've seen newsgroup or other forum posts from people asking if they can reuse some oft-repeated piece of text in Outlook. They come up with some odd way of reaching their goal, usually by trying some VBA and hooking the ActiveInspector to try and insert something. But there's a much easier way, with no code required.
Continue reading this entry »
-
About the Author
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA (or subscribe via email). Keep Reading »
About Code For Excel and Outlook
This site was created in November 2007 as a means to provide sample VBA code for programming projects. Currently there are- 295 blog posts,
- 75 pages,
- 1,027 comments,
- 17 categories,
- 559 tags, and
- Seven FREE Excel Add-Ins.
-
Recent Posts
-
Newsletter
If you'd like to receive occasional updates about the site, subscribe to my newsletter. -
Most Commented Posts
-
From my bookshelf
-
Affiliations
RSS Feed
Get Articles by Email
See all subscription options »
341 subscribers and counting!
Follow me on Twitter - 65 followers
