Multi-book desktop shortcut – Open Workbooks Simultaneously

Say, if you are preparing annual report say, AR.xlsx and there are four quarterly report files named Q1, Q2, Q3 and Q4 that you need to open and work with all these five files simultaneously. To do so, try to open them once from their individual locations one by one wherever they are saved.  Then, […]

Excel VBA – Add apostrophe before a field for Access Import

There are times, you try to import your data to Access but might not end successful due to some alpha numeric values in it. Access determines the type of field by accessing the first few rows of the column. If your data contains numeric values in the first few rows and alphanumeric in the rest […]

Office 2007 – Adding Custom Colors to Color Picker

The new color scheme introduced in Office 2007 looks impressive, but personally I feel,  it does lose a bit of important functionality when it comes to Charts. Excel Charts is an important tool in business areas to represent the facts graphically. Excel 2003 has a 56 color set, which allowed user to customize the color […]