Read Active Window and create a data base

Hi,

How exactly can I get the Active Window tittle text? Example : If I went to www.google.com it would return www.google.com OR if like Notepad is open and active it would say Notepad. I got the script, but I need to extend this to have log created in excel file.

Please Login or Register  to view this content.

Hi Shiva,

Newer versions of Excel have a new tool called Power Query. Power Query was built to deal with problems like yours. There is a new book called "M is for (DATA) Monkey" which tells about this new tool. For your exact problem read.

https://support.office.com/en-us/art...7-D3DA689091B5

Thanks Marvin,

However, I am using MSO version 10 at this point of time

Moreover I intend to use this on my student PC to see who is using what window during my assignment period. I have been trying to built this code quite some weeks now, but could not pass the stage yet.

Thanks,
Shiva

I guess I didn't understand your requirements. Have you considered a Screen Capture program to store what other screens are displayed?

or perhaps this link is closer to what you are trying to accomplish?

http://www.exceltip.com/files-workbo...oft-excel.html

More likely.. Ok here is what I am trying.. I have 10 student in my class. They are in the class for duration of 4 hours. In 4 hours, I give them assignment.
All of them use window station to practice with internet connection. But all 4 hours are not completely spent being training. They tend to use site surfing and some other activity.

1) I want to see how many hours they spend on each of the application in window. Say, while studying they login to Amazon.com then I want log to be created with start and end time or duration student was on Amazon.com.
2) I do not want to use excel, as I then need to keep excel open. hence I would like to create VB script which I can store in desktop and have it run before class starts.

All I want is if User goes to www.google.com it would return www.google.com OR if like Notepad is open and active it would say Notepad and log those information in some common drive path.

Hope this helps.

Thanks,
Shiva

Shiva

Surely there's dedicated software available to monitor the students internet activity.

Hi shiva,

This sounds like something that would be questioned as "privacy" in the USA. I think you are looking for a tool that would log browser history for you 10 student computers. Perhaps a tool like http://www.mobistealth.com/features/...ternet-logging that I know nothing about.