MS Office

30K

Solutions

96

Articles & Videos

6K

Experts

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Refine results

Is there a way to implement an auto save feature within Microsoft Word and Excel?  I ask because my users frequently work on very long documents and are not in the habit of saving as they work.

520 views

If right now a Windows search alternative is not something you want to use, then here are some fixes for when Windows 10 and Windows 8 search aren’t working properly.
 
The function that powers most…

112 views
How to tell Microsoft Office that a word is NOT spelled correctly

This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, incl…

4208 views

I am using office 365 2016 (64 bit) which has my Outlook Folders stored "in the cloud"

Periodically I want to back-up outlook folders that have changed since my last back-up.

I created two macros:

350 views

To enter a date is tricky
The Date Picker is a safe method to always ensure valid dates to be entered without noisy error messages disturbing the user. However, for many scenarios like accounting and…

9448 views
Excel Error Handling Part 3 -- Run and Fix Bugs

This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.

Part 1 of this series discussed basic error handling code using VBA.
http://www.exp…

069 views

I want to be able to run / open an Excel addin from a desktop Shortcut or batch file and have that addin read any command lines that were supplied in the 'Shortcut to' path in the shortcut file.

Is t…

1448 views

In previous video Micro Tutorials here at Experts Exchange, I discussed a feature of Nuance's PaperPort (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) software called the Send …

4416 views
Excel Error Handling Part 2 -- VBA to Copy Values Down to Blank Cells in an Excel Column

This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data…

134 views

Is there anything in an excel file that maintains the true file creation date.  A date that cannot be changed by copying the file etc ?

864 views

In a previous article here at Experts Exchange (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_12697-How-to-Install-Microsoft-Office-Picture-Manager-in-Office-2…

01,167 views
Excel Error Handling Part 1 -- Basic Concepts

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, t…

369 views

I need to go over all rows on Sheet1 in Column X, grab its value and then, see if value is BETWEEN numbers combination stored on Sheet 2 columns A and B. If value is between, then show value from Shee…

1030 views


In my travels in Experts-Exchange, I see people wanting to be an Expert and wanting to earn points. I wrote this article to help you earn points, to help you become an expert, and to use as a refere…

5542 views
How to install the Office 2016 desktop applications that come with the free trial of Office 365 Home

In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explai…

025 views

I have a spreadsheet.  I want to delete rows within the spreadsheet when cell in column 6 of that row contain a specific token.  How will I write a Excel VBA to perform such task?

728 views

Outlook 2016 for Mac Notes

The new Outlook for Mac promises to be a more familiar experience for PC users, at least at first glance.  The continuity for Mac users is also fairly good but not withou…

1481 views
How to get a free trial of Office 365 with the Office 2016 desktop applications

Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/p…

234 views

Hi All,

I have a set of MS Word macros which behave well on every system that I have tested, until yesterday.  I've discovered that MS Word is creating multiple instances of my VBA Project in the Pro…

2122 views

Microsoft finally put an end to the long wait of users for the launch of MS Office 2016. The version, released on September 22, 2015 is now available for the MS suite as well as in other packages like…

11,289 views
How to delete the Recently Browsed folder list in Microsoft Office Picture Manager

Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Instal…

016 views

I am trying to use a cell value to determine the sub called. The code follows - there are three, each attached to a button.
If the box on Enter Data is checked, Queries!G2 = "TRUE"
I have used this in…

922 views

Whilst the question related to PowerPoint and the VBA programming environment, the techniques in this article are equally relevant for any Microsoft Office application that supports ribbon extensibili…

3831 views
How to Install Microsoft Office Picture Manager in Office 2013

Microsoft Office Picture Manager is not included in Office 2013. This comes as quite a surprise to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was inc…

2343 views

Hi,

I would like to be able to click a button in Word 2010 and start a start a bullet list with the first Bullet Position=0.3cm and with the Text Indented= 0.8cm. Ideally I would prefer to customize …

1626 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Excel
    (125,180)
  2. MS Applications
    (44,167)
  3. Outlook
    (93,843)
  4. MS Word
    (26,652)
  5. MS Access
    (214,083)
  6. Visual Basic Classic
    (162,829)
  7. Exchange
    (195,997)
  8. Spreadsheets
    (5,733)
  9. Windows XP
    (118,086)
  10. Windows 7
    (42,788)