Consulting

Results 1 to 2 of 2

Thread: importing specific event log data into workbook

  1. #1
    VBAX Newbie
    Joined
    Mar 2015
    Posts
    1
    Location

    importing specific event log data into workbook

    I would like to import data from event code 100 from the Microsoft-Windows-Diagnostics-Performance/Operational log into a workbook. I want to get 2 columns, one of the date/time and the other of the boot time. The know the log file exists in C:\Windows\System32\winevt\Logs as an .evtx type file. I don't know how to do this or what the VBA command is to do this. I have done a little VBA programming.

  2. #2
    VBAX Mentor
    Joined
    Feb 2015
    Posts
    395
    Location
    Unless wanting to do this repeatedly probably no need for VBA. Standard functionality - import a text file and then AutoFilter

    Specifically on "Data" ribbon, option is "From Text", point at correct folder, change file type from "text files" to "all files" to see the file, select and import it and then take default wizard settings and click finish.
    Use Autofilter to select what you need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •