Microsoft Office | wisefaq.com

Semi-regular web-link clearance – May 2010 (2)

Make Outlook assign you random To-Do items

Sometimes, you have time to check something off your to-do list, but no one task is particularly pressing. Lifehacker Reader Ricardo shows us how to make Outlook pick a random one for you, so you can skip the decision-making and get to work.

Performance Analysis of Logs [...]

An easy way to do a PDF to Word conversion

Don’t you just hate it when, after you’ve spent quite a few hours on doing something, some smarty pipes up a suggestion which meant you’ve just lost those hours.

So it was with a 150+ page PDF to Microsoft Word conversion. Finished it, and to be honest, it was fairly crappy as the [...]

Remove hidden data from Microsoft Office documents.

I was sent a word document with "hidden data" in it.

"Hidden data" in Microsoft Word documents can be one of several bits of information, such as hidden data, change tracking, or even comments on the document.

Comments.

Such as this example:

This problem isn’t just limited to Microsoft Word, oh no. It [...]

So Outlook 2003 and 2007 store the email account details there.

Which you need to know BEFORE you rebuild your PC. (So you can take a backup copy of it).

Not that obvious until you need to know where to find it: HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Outlook\9375CFF0413111d3B88A00104B2A6676

The case of the broken Microsoft Word VBA application

It was a Microsoft Word (VBA) application written back in 2001.

Essentially what it does is:

user selects a letter type.
the user then enters some customer reference numbers.
the VBA application does an Oracle database lookup to convert those customer reference numbers into names and postal addresses.
which the VBA then uses to “mail merge” into whatever number of letters need to be sent out.

And it was broken.

I had a feeling that writing about patch management policy would come back to bite me (and it did).

(Click here to continue reading The case of the broken Microsoft Word VBA application)

“Developing For Office – Options and Trade-Offs”

According to Bruno Terkaly, you have three main choices:

Traditional Visual Basic for Applications (VBA) Dates back to all the way to the early nineties. Visual Studio Tools for Office. Really hit its stride and office 2007. It probably represents the best option moving forward today. It tries to be all things to [...]

wisefaq.com

Semi-regular web-link clearance – May 2010 (2)

An easy way to do a PDF to Word conversion

Remove hidden data from Microsoft Office documents.

So Outlook 2003 and 2007 store the email account details there.

The case of the broken Microsoft Word VBA application

“Developing For Office – Options and Trade-Offs”

Recent Comments

Blogroll

Twitter / Wisefaq