This is another VBA tips I learned with my Excel VBA project. Just wanted to share here for the future reference. Hope you can find it useful as well. The original post was found on tek-tips.com.
The following procedures demonstrate creating, copying, moving and deleting of files and folders using VBA: Continue reading
Recently I have been working on a VBA project, so I will post some skills or tips I learned and used on Excel VBA program. Today I will share how to change the cell background color in the VBA module.
The property of background color is , and the color is used as Index format. So to setup a cell (row ID: 1, column ID: 12) in Red background color is the below:
Worksheets(1).Cells(1,12).Interior.ColorIndex = 3 ‘change the background color to RED
And you can find more color index in the rest of my post. Continue reading
[Updated on 2008-12] This post can be treated as one of the “how-to” serials on Outlook tips.
I know we can export Contacts from Outlook directly into .csv (Comma Delimited) files, but not the same case in Distribution list. That is understandable since Distribution lists are not creating any new Contacts, just grouping these existing contacts.
But I need to export these Contacts into different .csv files based on the Distribution Lists I already created before. So I had to do extra steps to make the export happen.
Step 1: Save Distribution List as Text file