Friday, October 7, 2011

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 >>

Tuesday, April 26, 2011

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.

Thursday, April 14, 2011

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

Friday, March 18, 2011

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

Monday, February 14, 2011

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!