Category Archives: Microsoft Office metadata

Reviewing MS Office files

Introduction In previous articles, I talked about cataloguing a new hard drive, USB memory stick or network, and discussed approaches for investigating the file structure, the type of files, and the date ranges. In this fourth article I will be discussing in particular Microsoft Office files, namely MS Word, MS Excel and MS PowerPoint. I will be dealing with emails […]

Read more

Metadata contained in actual Microsoft PowerPoint files

It is possible that the metadata which is available to PowerPoint presentations might be actually be used in real-life presentations. Therefore, 1,180 PowerPoint presentations were downloaded at random (see methodology), and the metadata extractor Filecats Professional imported the metadata into Microsoft Excel in order to find out what document properties were actually used. The results are as follows: Common metadata […]

Read more

Metadata contained in actual Microsoft Excel files

Whilst it may be interesting to know in theory what metadata is available for use in Excel documents, the actual document properties used in real Excel spreadsheets might be different. To find this out, 1,113 Excel workbooks were downloaded at random (see methodology), and the metadata extractor Filecats Professional has been used to extract the metadata to see what document […]

Read more

Accessing metadata from multiple Microsoft Office documents

Introduction My previous article discussed the various different metadata fields that are available in Microsoft Office documents. This article will discuss ways of accessing these fields in multiple documents. It will start with looking at VBA, and then talk about an easier way. Using Visual Basic for Applications As shown in the VBA article, it is possible to read document […]

Read more

Reading metadata from within Microsoft Office VBA

Table of contents Page 1 Microsoft Office Document Properties (Metadata) – Introduction Page 2 Microsoft Word Properties – Introduction. Page 3 Accessing Microsoft Office Properties in the File Menu This Page Accessing MS Office Properties through VBA – see below. Page 5 Pictures and Photographs document properties Je voudrais lire ceci en français. Me gustaría leer esto en español. Ich […]

Read more