Hi,
I'm trying to write a macro that records the titles of the active window, together with the times that window was active for (i.e. start and finish time). The macro should run in the background all day long and record until closed.
Please note that I mean Windows window, not Excel Workbook.
only seems to report the Excel workbook.
I'm guessing I need to use Windows API, but not sure what and how.
Any help would be appreciated--I'll also post any solutions here.
I'm trying to write a macro that records the titles of the active window, together with the times that window was active for (i.e. start and finish time). The macro should run in the background all day long and record until closed.
Please note that I mean Windows window, not Excel Workbook.
Code:
ActiveWindow.CaptionI'm guessing I need to use Windows API, but not sure what and how.
Any help would be appreciated--I'll also post any solutions here.
