PDA

View Full Version : importing specific event log data into workbook



junksasa
03-09-2015, 12:23 PM
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.

Yongle
03-09-2015, 10:21 PM
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