Skip to main content

How do you read dump files that are created after blue screen error

You have some ways to investigate the reason of blue screen error (BSOD – Blue Screen of Death). After you face an error like below and restart it, check the mini dump file which is located under C:\Windows\Minidump

Scary blue screen

The ways to read dump files:

Getting more information about blue screen error by using WinDbg

Outlook Macro for moving specific mails and reading their content

I have just finished off developing this macro. It is my first project which I uploaded SourceForge. In order to download code, follow this link: https://sourceforge.net/projects/outlookmacro/

What does this macro do?

  • Find the mails which have the specific subject in Inbox folder (In this case, subject is “New resume has been received!”)
  • Creating a mail folder named like Resumes 8/26/2012 1:29:50 PM under Inbox.

    The folder that created by macro
  • Moving those mails to Inbox > Resumes 8/26/2012 1:29:50 PM
  • Creating a local folder named like Resumes 8/26/2012 1:29:50 PM under C: drive
  • Saving those mails’ attachments under C:\Resumes 8/26/2012 1:29:50 PM

    Attachments are saved under C: drive
  • Reading content of those mails and creating Excel file

Notes:
– A reference named “Microsoft Excel 14.0 Object Library” must be added
– It searchs mails under only Inbox folder

Solved: “User-defined type not defined” error at declarations of Excel variables (VBA)

You may face “User-defined type not defined” error as you declare Excel specific variables. This issue is little tricky.

Your code may be like this:

Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Dim xlSheet As Excel.Worksheet
You are missing a reference

Solution

This error occurs because of the missing reference. You should add Excel reference before declaring Excel objects. To get rid of this error:

  • Go to “Tools > References” in VBA compiler
  • Add “Microsoft Excel 14.0 Object Library”

    Adding Excel Object Library as a reference