Articles & Videos
This topic covers Office installation and licensing (including Office 365) in both Windows and Macintosh versions. It also includes questions for Office apps that don’t have a dedicated topic, such as Publisher, InfoPath, or Project. Some Microsoft Office apps have dedicated topics, such as Word, Excel, Access, Outlook, PowerPoint & Visio; please post in those subtopics when applicable. Important: please specify which version of Office you use when asking the question.
We created a powerpoint presentation with a mp4 video inserted into the second slide. I provided it to another user but the video does not display even though I also provided the file also which has …
Rounding should be right at hand
In many areas, rounding that accurately follows specific rules are needed - accounting, statistics, insurance, etc.
Unfortunately, the native functions of VBA th…
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.
Start with data in a poor structure:
Create a table on …
We have a user running Windows 7 Pro along with Office 365 and all of a sudden they constantly get the "Microsoft has stopped working" message. We have disabled all addins and it happens even in safe…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and f…
This Micro Tutorial will demonstrate in Microsoft Excel, Word, and Google docs how to simplify your content using format painters.
We converted access 2003 to 2010 about 6 months ago and although
numerous issues popped up we have been able to resolve them. This one I can't!
When trying to edit an active x object, Common dial…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbo…
I am looking for VBA code that will:
Then Count by Product line so that I have one row per Product line with the count of items
As shown in the att…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/wo
In MS Project 2010 while in a resource sheet you were able to add recourse - address book and select from your Outlook contacts in your Outlook.
With 2013 when we try to do this we get an error:
MS outlook is a premier email client that enable you to send and receive the e-mails with various file formats of attachments such as document files, media file, and many others formats. There is some…
I have two KMS hosts on network, when deployed a machine recently using kace appliance i had issue with office 2010 not being activated via KMS, however win7 pro actiavted just fine.
slmgr /dlv show…
This article describes how to add commands to the Quick Access Toolbar (QAT). The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific ste…
I am using the below code to clear from Name manager. Seemed to work fine last week now I am getting Run Time Error
Dim n As Name
For Each n In Names
I've recently encountered several questions about converting RTF (Rich Text Format) to plain text. This article shows an easy, fast, and free class module that will provide this function…
I'm selling childrenbooks to a few primary schools and wanted some help in managing my inventory.
I've setup a spreadsheet and EE have helped in making some improvements but I'm struggling w…
In his recent article, http:A_13877.html , DrTribos faced the problem of assigning MS Word property values with a string variable equal to the name of one of the enum constants.
I would like to run a macro with the following requirements:
Copy the first row (header row with column captions) of the file 'MyHeaderFile' located in D:\MyData\MyHeaderFile.xl…
Cannot open your default e-mail folders. The file C:\Users\XXXXX\AppData\Loc
How to repair …
I have two tables of information:
They identify and show how people feel about carrying out duties pre and post training.
I can not figure out how to put the two sets of data into a graph which …
I'm trying to find the first occurrence of a values in a column (Conflict Name) and then write the result to a new column. Example below:
LA-Merge Suppliers*Invoice Apply Prepayments…
Hi, in MS Excel I have 10,000 rows of data in 35 columns in Worksheet A, the unique identifier for each row is contained in Column C called the SaleID which is alphanumeric (sometimes an Integer or s…
I had to rework my code to account for 64 bit functionality.
For some reason, certain parts still result in errors, does anyone see why that would be?
I recently installed Microsoft Office 2013 on a new computer and was disappointed to discover that Microsoft Office Picture Manager is not included in Office 2013. This article explains how to corre…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dic…
9,700 points this week
6,800 points this week
Kanpur University, Uttar Pradesh, India
5,600 points this week
Greater Chicago Area, United States
4,451 points this week
[ fanpages ]
United Kingdom; London, & surrounding areas
4,400 points this week