Using Access Data in Excel

Did you know there are three ways how to use Access data in Excel?

Whether you have an existing database, or you set up a fresh database for your data see Access blog's posting for the tips. You will learn all the different methods how to bring Access data into Excel for analysis.

Ways to use Access data in Excel >>

Excel VBA: How to Break Links to External Workbooks

Back in 2007 one of the prettiest pieces of VBA code was given free to the people. If you have ever needed a good programmatic way to remove all external workbook links from a single workbook, check this link.

Top Microsoft Twitter Accounts Every Cubicle Worker Shoud Follow

@MSExcel - Official Twitter account of the product team that brings to you a little piece of software we call Excel.

@msaccess - I am Ryan McMinn a Program Manager on the Access Team; email me at ryan.mcminn@microsoft.com

@Office - Tweets to help you do more with Office at work, home and school. 

@OfficeBI - Covering Microsoft's Business Intelligence products on the Office Platform including SharePoint, Excel, & Excel Services.

@Office_Live - Tweets from the team at Microsoft Office Live

@SharePoint - The SharePoint Product Group

@ch9 -  Channel 9 keeps you up to date with videos from people behind the scenes building products at Microsoft.

Excel VBA: Remove All Conditional Formatting From Sheet

At times you may experience issues with macros when having lots of conditional formatting rules on a sheet. Here's the magic with which you can remove all conditional formatting rules from a sheet:

Sheets("MySheet").Cells.FormatConditions.Delete

Show Details On-demand in Excel

Excellent sample of how to create an on-demand details chart - by Chandoo.org.

How to Delete a Folder from Command Prompt

Occasionally the best method for removing directories is using good ol' Command Prompt. Such case might be for example when you need to bypass Windows' directory path limitations.

Use commands RMDIR or RD in Command Prompt to remove directories.

Here's the syntax and parameters for RMDIR and RD:

Removes (deletes) a directory.

RMDIR [/S] [/Q] [drive:]path
RD [/S] [/Q] [drive:]path

    /S      Removes all directories and files in the specified directory
            in addition to the directory itself.  Used to remove a directory
            tree.

    /Q      Quiet mode, do not ask if okd to remove a directory tree with /S

Save Valentine's Day With Excel

Forgot to get something nice for your Valentine? Don't worry - Debra shows how Excel can save you!

Excel: How to Open Files in New App Instances

I know you've cried and yelled when a certain workbook crashes your Excel - and corrupts the other open workbook(s) too.

Here's an old but still relevant tip from Virgilio Adriano on how to open Excel files in a new application instance.

Tips: add a new context menu item to make this feature available on need -basis, or make it the default behaviour!