Category: Microsoft Office

Microsoft Office Configuration Analyzer Tool 2.2
article #1012, updated 131 days ago

Something very like a best practices analyzer / BPA for Office, 32-bit and 64-bit, versions 2007 and newer, both MSI and click-to-run:

Categories:   Microsoft Office   Office 365


Excel falsely reports "cannot open or save any more documents because there is not enough available memory or disk space"
article #994, updated 189 days ago

There are many situations in which a recent version of Excel will report that there is not enough available memory or disk space, where there very clearly is. To knock this one out, go to File menu and Options, click Trust Center on the left, click Trust Center Settings… on the right, and then Protected View on the left. Uncheck everything in there, and OK all the way out. Close Excel and try it again. Problem eliminated.

Categories:   Microsoft Office   Office 365


Import Multiple CSVs to Tabs in One Excel Spreadsheet
article #763, updated 864 days ago

From the excellent Jerry Beaucaire; VBA, for use inside an Excel module.

Sub ImportCSVs()
'Author:    Jerry Beaucaire
'Date:      8/16/2010
'Summary:   Import all CSV files from a folder into separate sheets
'           named for the CSV filenames
'Update:    2/8/2013   Macro replaces existing sheets if they already exist in master workbook
'Modded:    12/10/14   Minor edits (Jonathan Brickman)

Dim fPath       As String
Dim fCSV        As String
Dim SheetName   As String
Dim wbCSV       As Workbook
Dim wbMST       As Workbook

Set wbMST = ThisWorkbook
fPath = "X:\PATH-TO-CSVs\"       'path to CSV files, include the final \
Application.ScreenUpdating = False  'speed up macro
Application.DisplayAlerts = False   'no error messages, take default answers
fCSV = Dir(fPath & "*.csv")         'start the CSV file listing

    On Error Resume Next
    Do While Len(fCSV) > 0
        SheetName = Left(fCSV, Len(fCSV) - 4)   ' Trim .CSV from filename, make sheet name
        Set wbCSV = Workbooks.Open(fPath & fCSV)                    'open a CSV file
        wbMST.Sheets(ActiveSheet.Name).Delete                       'avoid replication, delete sheet
        ActiveSheet.Move After:=wbMST.Sheets(wbMST.Sheets.Count)    'move new sheet into Mstr
        ActiveSheet.Name = SheetName
        Columns.AutoFit             		'clean up display
        fCSV = Dir                  		'ready next CSV

Application.ScreenUpdating = True
Set wbCSV = Nothing
End Sub

Categories:   Microsoft Office   


Manually remove Office 95, 97, 2000, XP, 2003, 2007, 2010
article #234, updated 937 days ago

Fix-Its now exist for Office 2010, 2007, and 2003:

A utility for manual removal of Office versions at and before XP, is here:

Categories:   Microsoft Office   Cleanup


Get, Set, Activate, and Do Lots More Things for Office Keys
article #717, updated 972 days ago

To get current keys, this is excellent:

Here’s a command line which works on Microsoft Office 2013 32-bit, on a 64-bit system, to get the key identifier (last set of characters):

cscript "C:\Program Files (x86)\Microsoft Office\Office15\OSPP.VBS" /dstatus

The above can work in a CMD, even a remote CMD. The script does a lot of different things; for a list on the above system, try this, from the console only:

cscript "C:\Program Files (x86)\Microsoft Office\Office15\OSPP.VBS" 

Categories:   Microsoft Office   


When Office 2013 Crashes Due To DirectX (ATIDxx64/32.dll)
article #676, updated 1116 days ago

This is a situation in which Office 2013, either 32-bit or 64-bit, will not run on any install. The way to handle it, is to disable “hardware acceleration” by registry entry. Go here:


then create key Graphics, and then in that key a DWORD DisableHardwareAcceleration, set value to 1 for disable.

Categories:   Microsoft Office